recently installed program

myITforum.com Community Forum

Home Forums Blogs Live Support chat Search Articles Wiki FAQ Email Lists Register Login My Profile Inbox Address Book My Subscription My Forums

Photo Gallery Member List Search Calendars FAQ Ticket List Log Out

All Forums RSS Feed Subscription:

recently installed program

View related threads: (in this forum | in all forums)

Logged in as: Guest

Printable Version

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> recently installed program

Page: [1]

Message

<< Older Topic Newer Topic >>

recently installed program - 9/24/2008 10:17:34 PM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

is there anyway you can use SMS to track software that was recently installed? What i am getting at is that i want to be notified or find some way to track if a laptop/s has had a certain program/s installed that shouldn't be there. I am referring to a program a user would have obtained illegally from somewhere and put it onto their laptop without proper permission.

Post #: 1

RE: recently installed program - 9/25/2008 7:55:31 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

Try this, but keep in mind that not all program will populate the Installed Date.

http://smsug.ca/blogs/garth_jones/archive/2008/09/25/resently-installed-programs.aspx

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to alokin123)

Post #: 2

RE: recently installed program - 9/25/2008 11:08:55 PM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

thanks for that. I've tried setting up a report with that but it comes up with page cannot be displayed

(in reply to alokin123)

Post #: 3

RE: recently installed program - 9/26/2008 2:12:00 AM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

ok, well i am using MS query via excel and can get the results fine using that into a spreadsheet:

SELECT v_GS_COMPUTER_SYSTEM.Name0, v_GS_COMPUTER_SYSTEM.UserName0, v_GS_INSTALLED_SOFTWARE.ProductName0, v_GS_INSTALLED_SOFTWARE.VersionMajor0, v_GS_INSTALLED_SOFTWARE.VersionMinor0, v_GS_INSTALLED_SOFTWARE.Publisher0, v_GS_INSTALLED_SOFTWARE.RegisteredUser0, v_GS_INSTALLED_SOFTWARE.InstallDate0, v_GS_INSTALLED_SOFTWARE.InstallSource0
FROM SMS_P0D.dbo.v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM, SMS_P0D.dbo.v_GS_INSTALLED_SOFTWARE v_GS_INSTALLED_SOFTWARE
WHERE v_GS_COMPUTER_SYSTEM.ResourceID = v_GS_INSTALLED_SOFTWARE.ResourceID

is it not working in the reports for SMS because its returning to much data or am i just doing something wrong?

(in reply to alokin123)

Post #: 4

RE: recently installed program - 9/26/2008 1:34:51 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

It is possible that the query is returning too much data. How many clients do you have?

BTW if SMS/ConfigMgr can't return that much data then Excel is most likely not returning all the data too.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to alokin123)

Post #: 5

RE: recently installed program - 9/28/2008 11:39:56 PM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

we have about 900 clients. Excel is returning about 60 000 rows. Is there a tweak i can do to get the report page to work?
If not, that's fine i was only really trying to report on certain products so i have specified these in my query.
Thanks for your help!

(in reply to gjones)

Post #: 6

RE: recently installed program - 9/29/2008 8:16:09 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

Web reports should have no problems returning that little of data. What error message are you getting again?

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to alokin123)

Post #: 7

RE: recently installed program - 9/29/2008 6:12:48 PM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

its attached (i think). In any case its HTTP 500 Internal Server Error
The website cannot display the page

Thumbnail Image

Attachment (1)

(in reply to gjones)

Post #: 8

RE: recently installed program - 9/30/2008 8:13:17 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

quote:

ORIGINAL: alokin123
its attached (i think). In any case its HTTP 500 Internal Server Error
The website cannot display the page

Stupid question but do other reports work? If so have you look at the troubleshooting tips within the Help file? http://technet.microsoft.com/en-ca/library/bb632969.aspx

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to alokin123)

Post #: 9

RE: recently installed program - 9/30/2008 10:50:02 AM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

I'm getting the Same Error.
and yes all my other reports work fine, and we only have 800 users and 1200 PCs.

Thumbnail Image

Attachment (1)

(in reply to gjones)

Post #: 10

RE: recently installed program - 9/30/2008 11:04:12 AM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

If I simplify the Query to some basics, then the report will be fine.

I removed the red stuff.

SELECT
   CS.Name0,
   CS.UserName0,
   ISW.ProductName0,
   ISW.InstallDate0,

   ISW.VersionMajor0,
   ISW.VersionMinor0,
   ISW.Publisher0,
   ISW.RegisteredUser0,
   ISW.InstallSource0


FROM
   dbo.v_GS_COMPUTER_SYSTEM CS,
   dbo.v_GS_INSTALLED_SOFTWARE ISW
WHERE
   ISW.ResourceID = CS.ResourceID
ORDER BY
   ISW.InstallDate0 DESC,
   CS.Name0,
   CS.UserName0,
   ISW.ProductName0

Now I'll try to add each one of the red and see which will not return data.

(in reply to MeenEnta)

Post #: 11

RE: recently installed program - 9/30/2008 11:11:33 AM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

I'm going to try to adjust the report to go beyond the 10K lines.

(in reply to MeenEnta)

Post #: 12

RE: recently installed program - 9/30/2008 11:15:23 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

It sound like your ASP cache is too small or the query is timing out, there are some reg key to fix that. I don't have them handy.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to MeenEnta)

Post #: 13

RE: recently installed program - 9/30/2008 11:48:20 AM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

Small on the SITE server or on the console machine?

I've increased it to MAX (5+ GB) on the console machine and still no GO.

(in reply to gjones)

Post #: 14

RE: recently installed program - 9/30/2008 12:27:21 PM 1 votes

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

Check out both FAQ for Q 6 & 7
http://www.microsoft.com/technet/sms/2003/library/techfaq/tfaq10.mspx

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to MeenEnta)

Post #: 15

RE: recently installed program - 9/30/2008 2:02:04 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

Editing the XML is what did the trick for me.

It's working fine now, little heavy on the server, 8 seconds to run, not bad.

Thx Garth,

(in reply to gjones)

Post #: 16

RE: recently installed program - 9/30/2008 2:31:58 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

I've changed it little bit to also prompt for computer if needed. (less taxing on Server).

SELECT
CS.Name0,
   CS.UserName0,
   ISW.ProductName0,
   ISW.VersionMajor0,
   ISW.VersionMinor0,
ISW.Publisher0,
ISW.RegisteredUser0,
ISW.InstallDate0,
ISW.InstallSource0
FROM
   dbo.v_GS_COMPUTER_SYSTEM CS,
   dbo.v_GS_INSTALLED_SOFTWARE ISW
WHERE
   ISW.ResourceID = CS.ResourceID and CS.Name0 like @ComputerName
ORDER BY
   ISW.InstallDate0 DESC,
   CS.Name0,
   CS.UserName0,
   ISW.ProductName0

and here's the Prompt SQL:

begin
if (@__filterwildcard = '')
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0
else
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.Netbios_Name0 like @__filterwildcard
ORDER By SYS.Netbios_Name0
end

Thx again Garth.

(in reply to MeenEnta)

Post #: 17

RE: recently installed program - 9/30/2008 3:13:11 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

quote:

ORIGINAL: MeenEnta
here's the Prompt SQL:

begin
if (@__filterwildcard = '')
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS ORDER By SYS.Netbios_Name0
else
SELECT DISTINCT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.Netbios_Name0 like @__filterwildcard
ORDER By SYS.Netbios_Name0
end

I wouldn't use the v_R_System for the prompt, instead I would use v_GS_Computer_System

begin
if (@__filterwildcard = '')
SELECT DISTINCT CS.Name0 From dbo.v_GS_COMPUTER_SYSTEM CS Order by CS.Name0 else
SELECT DISTINCT CS.Name0 From dbo.v_GS_COMPUTER_SYSTEM CS
WHERE CS.Name0 like @__filterwildcard + '%'
ORDER By CS.Name0
end

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to MeenEnta)

Post #: 18

RE: recently installed program - 9/30/2008 3:29:13 PM

jnelson993

Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

quote:

I wouldn't use the v_R_System for the prompt, instead I would use v_GS_Computer_System
begin
if (@__filterwildcard = '')
SELECT DISTINCT CS.Name0 From dbo.v_GS_COMPUTER_SYSTEM CS Order by CS.Name0
else
SELECT DISTINCT CS.Name0 From dbo.v_GS_COMPUTER_SYSTEM CS
WHERE CS.Name0 like @__filterwildcard + '%'
ORDER By CS.Name0
end

Pay no attention to that crazy man. Use v_R_System if you want to!

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gjones)

Post #: 19

RE: recently installed program - 9/30/2008 4:08:10 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

quote:

ORIGINAL: jnelson993
Pay no attention to that crazy man. Use v_R_System if you want to!

What you talking about Willis!

Use v_R_System only if you want extra PCs which don't have data within the report.

psss, John is really the crazy man.

lol

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to jnelson993)

Post #: 20

RE: recently installed program - 9/30/2008 5:22:02 PM

MeenEnta

Posts: 107
Score: 0
Joined: 9/9/2008
Status: offline

Can't we all get along!!?

I Love you both.

and Thank you.

(in reply to gjones)

Post #: 21

RE: recently installed program - 9/30/2008 5:36:18 PM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

quote:

ORIGINAL: MeenEnta

Can't we all get along!!?

I Love you both.

and Thank you.

Yes, We will both go for drinks at MMS, as we do each year..

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to MeenEnta)

Post #: 22

RE: recently installed program - 9/30/2008 5:56:13 PM

jnelson993

Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Absolutely, it's all in good fun. I don't really blame him anyway. After all...he is Canadian.

Up there, if you dissent from using v_GS_Computer_System, I think you could get hauled in front of the "human rights" tribunals like Mark Steyn

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to gjones)

Post #: 23

RE: recently installed program - 10/1/2008 12:31:49 AM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

thanks for the tip.

Now, on to a related question. I seem to be finding some discrepancies.
If i do that report it returns that i have 72 versions of MS Office Project Professional 2007 but yet if i run License 1A - Microsoft License Ledger for Microsoft License Statements it tells me i have i have 69. So my question is, is v_GS_INSTALLED_SOFTWARE the best table to query on? I know its not much of a difference and the other products are showing discrepancies by a few numbers as well. I've tried HS_ADD_REMOVE_PROGRAMS and that just seems way off in terms of numbers.

(in reply to jnelson993)

Post #: 24

RE: recently installed program - 10/1/2008 8:46:49 AM

gjones

Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline

quote:

ORIGINAL: alokin123
I've tried HS_ADD_REMOVE_PROGRAMS and that just seems way off in terms of numbers.

v_HS_* are history views. You always want to look at v_GS_* for current data.

_____________________________

Garth@enhansoft.com

For a List of my Articles
http://www.myitforum.com/contrib/default.asp?cid=116
Blogs:
http://smsug.ca/blogs/garth_jones/default.aspx
http://myitforum.com/cs2/blogs/gjones/default.aspx

(in reply to alokin123)

Post #: 25

RE: recently installed program - 10/9/2008 10:47:10 PM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

sorry to return to this. i have only just had chance to edit the xml file as suggested in the FAQ and it still doesn't work for the query. I am still getting HTTP 500 Internal Server Error. Anything else i can try?

(in reply to gjones)

Post #: 26

RE: recently installed program - 10/9/2008 10:51:57 PM

alokin123

Posts: 28
Score: 0
Joined: 8/7/2008
Status: offline

actually, dont worry i worked it out

(in reply to alokin123)

Post #: 27