recently installed program (Full Version)

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



Message

alokin123 -> recently installed program (9/24/2008 10:17:34 PM)

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.



gjones -> RE: recently installed program (9/25/2008 7:55:31 AM)

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
 



alokin123 -> RE: recently installed program (9/25/2008 11:08:55 PM)

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



alokin123 -> RE: recently installed program (9/26/2008 2:12:00 AM)

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?



gjones -> RE: recently installed program (9/26/2008 1:34:51 PM)

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.



alokin123 -> RE: recently installed program (9/28/2008 11:39:56 PM)

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!



gjones -> RE: recently installed program (9/29/2008 8:16:09 AM)

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



alokin123 -> RE: recently installed program (9/29/2008 6:12:48 PM)

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


[image]local://upfiles/40784/B49E60235CE945158FFC5289C02FE4AC.jpg[/image]



gjones -> RE: recently installed program (9/30/2008 8:13:17 AM)

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 



MeenEnta -> RE: recently installed program (9/30/2008 10:50:02 AM)

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

[image]local://upfiles/40892/B2A6A6CF2F614F72AAD04392CC43C14C.gif[/image]



MeenEnta -> RE: recently installed program (9/30/2008 11:04:12 AM)

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.



MeenEnta -> RE: recently installed program (9/30/2008 11:11:33 AM)

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



gjones -> RE: recently installed program (9/30/2008 11:15:23 AM)

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.



MeenEnta -> RE: recently installed program (9/30/2008 11:48:20 AM)

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.



gjones -> RE: recently installed program (9/30/2008 12:27:21 PM)

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



MeenEnta -> RE: recently installed program (9/30/2008 2:02:04 PM)

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,



MeenEnta -> RE: recently installed program (9/30/2008 2:31:58 PM)

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.
 



gjones -> RE: recently installed program (9/30/2008 3:13:11 PM)

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



jnelson993 -> RE: recently installed program (9/30/2008 3:29:13 PM)

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! [:D]



gjones -> RE: recently installed program (9/30/2008 4:08:10 PM)

quote:

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


[8D] What you talking about Willis! [8D]

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. [:D] lol



MeenEnta -> RE: recently installed program (9/30/2008 5:22:02 PM)

Can't we all get along!!?

I Love you both.

and Thank you.



gjones -> RE: recently installed program (9/30/2008 5:36:18 PM)

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.. [:D]



jnelson993 -> RE: recently installed program (9/30/2008 5:56:13 PM)

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

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 [:D]




alokin123 -> RE: recently installed program (10/1/2008 12:31:49 AM)

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.



gjones -> RE: recently installed program (10/1/2008 8:46:49 AM)

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.



alokin123 -> RE: recently installed program (10/9/2008 10:47:10 PM)

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?



alokin123 -> RE: recently installed program (10/9/2008 10:51:57 PM)

actually, dont worry i worked it out



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.3125