Creating New report to detail what Games are installed (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> Web Reporting



Message

sconnell -> Creating New report to detail what Games are installed (5/7/2008 7:45:42 PM)

I would like to know if it's possible to create a report to show what games are installed on PC's in our organization? If so does anyone have one out there?



jnelson993 -> RE: Creating New report to detail what Games are installed (5/8/2008 10:40:28 AM)

Do you have SMS SP3 installed?



rtruss -> RE: Creating New report to detail what Games are installed (5/8/2008 10:45:39 AM)

Either way that could be a daunting task.  You could just run a report to list what shows up in add or remove programs and then use excel to remove the non game listings.



jnelson993 -> RE: Creating New report to detail what Games are installed (5/8/2008 12:49:01 PM)

Yeah, it'll be a bit of work, but I don't see it as that daunting if you've got SP3 because of the classification of software.  Just query V_GS_INSTALLED_SOFTWARE_CATEGORIZED for everything that has the right family/category.   It's even better in SCCM and Asset Intelligence 1.5 :)

SELECT  
  ResourceID,
  NormalizedName,
  NormalizedPublisher,
  FamilyName,
  CategoryName
FROM    
  dbo.v_GS_INSTALLED_SOFTWARE_CATEGORIZED
WHERE
  FamilyName LIKE '%GAME%'
  OR CategoryName LIKE '%GAME%'
ORDER BY
  FamilyName,
  CategoryName,
  NormalizedName,
  NormalizedPublisher



rtruss -> RE: Creating New report to detail what Games are installed (5/8/2008 4:43:36 PM)

Nice report!  I took it one step farther so you can see who may have installed it and on what system.


SELECT
GAMES.ProductName0 as "Game Name", 
GAMES.NormalizedPublisher AS "Publisher",
SYS.Name0 AS "Computer Name",
SYS.Resource_Domain_OR_Workgr0 AS "Registered Domain", 
SYS.User_Name0 AS "User Name",
GAMES.FamilyName As "Family",
GAMES.CategoryName AS "Category", 
SYS.Operating_System_Name_and0 AS "Operating System",
SYS.ResourceID
FROM
v_GS_INSTALLED_SOFTWARE_CATEGORIZED GAMES
INNER JOIN
v_R_System SYS on SYS.ResourceID=GAMES.ResourceId
WHERE
GAMES.FamilyName LIKE '%GAME%'
OR
GAMES.CategoryName LIKE '%GAME%'
ORDER BY
"Game Name",
Publisher,
"Computer Name",
Family,
Category



sconnell -> RE: Creating New report to detail what Games are installed (5/8/2008 9:39:12 PM)

Rtruss,
I get this error message when I added this to a new report that i tried to create.



An error occurred when the report was run. The details are as follows:Invalid object name 'v_GS_INSTALLED_SOFTWARE_CATEGORIZED'.






Error Number:
-2147217865

Source:
Microsoft OLE DB Provider for SQL Server

Native Error:
208



jnelson993 -> RE: Creating New report to detail what Games are installed (5/9/2008 9:24:54 AM)

If you don't have SMS 2003 Service Pack 3 then you won't have any of the Asset Intelligence views (INSTALLED SOFTWARE, INSTALLED SOFTWARE CATEGORIZED, etc.)

So...do you have SP3?



sconnell -> RE: Creating New report to detail what Games are installed (5/9/2008 11:19:48 AM)

SP2. I will install sp3 and give it a try.



sconnell -> RE: Creating New report to detail what Games are installed (5/9/2008 3:17:13 PM)

Okay I have installed SMS 2003 SP3 file name SMS2003sp3.exe with file size of 144mb and when I created a report from the above listed I get no matches found. I know for a fact that I got PC's out there with games, so did I miss something? Thanks for you help Guys.



jnelson993 -> RE: Creating New report to detail what Games are installed (5/9/2008 4:49:09 PM)

Well, the service pack on the server is one part, now you have to install the updated SMS client to all of your machines.  Until there are updated clients, there won't be any data there.



jnelson993 -> RE: Creating New report to detail what Games are installed (5/9/2008 4:53:29 PM)

http://myitforum.com/cs2/blogs/socal/archive/2007/05/12/sms-2003-sp3-upgrade-checklist.aspx



sconnell -> RE: Creating New report to detail what Games are installed (5/9/2008 8:23:00 PM)

okay I have updated the SMS server with SMS 2003 SP3 and then did and advanced client push to all my systems. How can I tell what version the clients have and how long would you expect it to take for roughly 750 machines?



jnelson993 -> RE: Creating New report to detail what Games are installed (5/12/2008 10:32:50 AM)

There's a report called "Count SMS client versions" (report 72) that you can use to see the versions on the clients.

How long depends on a lot of factors, but for 750, I'd expect you'll be getting 90% within a couple of days.



bwoodall -> RE: Creating New report to detail what Games are installed (5/14/2008 10:34:15 AM)

I am running SMS 2003 SP3 with all advanced clients version 2.50.4160.2000. The version of SQL is 2000 SP4 but recieve the following error message also when trying to run the report. I looked at the views in the site database and v_GS_INSTALLED_SOFTWARE_CATEGORIZED can't be located. Any suggestions?


An error occurred when the report was run. The details are as follows:Invalid object name 'v_GS_INSTALLED_SOFTWARE_CATEGORIZED'.






Error Number:
-2147217865

Source:
Microsoft OLE DB Provider for SQL Server

Native Error:
208



jnelson993 -> RE: Creating New report to detail what Games are installed (5/14/2008 11:15:19 AM)

If the views aren't there and all your advanced clients are 2.50.4160.2000 then I'd say you're probably only on SP2 (that .2000 indicates SP2).  SP3 is 2.50.4253.3000 (or higher if you've installed the post-SP3 rollup)
http://myitforum.com/cs2/blogs/socal/archive/2007/05/12/sms-2003-sp3-upgrade-checklist.aspx




bwoodall -> RE: Creating New report to detail what Games are installed (5/14/2008 11:31:15 AM)

This is what is reported when I right click on Site Database - About SMS

Site Server - 2.50.4160.2000 (4160)
Admin UI - SMS 2.50 SP3 (4253)
SMS Provider - 2.50.4160.2000

This is what is reported on client versions.





2.50.3174.1018 
1 
1 

2.50.4160.2000 
1
3722 



gjones -> RE: Creating New report to detail what Games are installed (5/14/2008 11:36:14 AM)

Those version number mean you are SP2.



bwoodall -> RE: Creating New report to detail what Games are installed (5/14/2008 11:45:48 AM)

OK I see says the blind man. Only the Admin UI is on SP3. I will begin the upgrade process after reviewing the checklist.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.3583984