myITforum.com Community Forum 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:


           



Creating New report to detail what Games are installed

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

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> Web Reporting >> Creating New report to detail what Games are installed Page: [1]
Login
Message << Older Topic   Newer Topic >>
Creating New report to detail what Games are installed - 5/7/2008 7:45:42 PM   
sconnell

 

Posts: 47
Score: 0
Joined: 7/6/2007
Status: offline 		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?
Post #: 1
RE: Creating New report to detail what Games are installed - 5/8/2008 10:40:28 AM   
jnelson993


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		Do you have SMS SP3 installed?

_____________________________

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

(in reply to sconnell)
Post #: 2
RE: Creating New report to detail what Games are installed - 5/8/2008 10:45:39 AM   
rtruss


Posts: 230
Score: 10
Joined: 11/4/2004
Status: offline 		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.

_____________________________

Roger Truss
Assistant Windows Administrator
SMS Admin
Trend Micro Admin
ImageUltra Admin

Please rate my post ;)

(in reply to jnelson993)
Post #: 3
RE: Creating New report to detail what Games are installed - 5/8/2008 12:49:01 PM   
jnelson993


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		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


_____________________________

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

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


Posts: 230
Score: 10
Joined: 11/4/2004
Status: offline 		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

_____________________________

Roger Truss
Assistant Windows Administrator
SMS Admin
Trend Micro Admin
ImageUltra Admin

Please rate my post ;)

(in reply to jnelson993)
Post #: 5
RE: Creating New report to detail what Games are installed - 5/8/2008 9:39:12 PM   
sconnell

 

Posts: 47
Score: 0
Joined: 7/6/2007
Status: offline 		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

(in reply to rtruss)
Post #: 6
RE: Creating New report to detail what Games are installed - 5/9/2008 9:24:54 AM   
jnelson993


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		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?


_____________________________

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

(in reply to sconnell)
Post #: 7
RE: Creating New report to detail what Games are installed - 5/9/2008 11:19:48 AM   
sconnell

 

Posts: 47
Score: 0
Joined: 7/6/2007
Status: offline 		SP2. I will install sp3 and give it a try.

(in reply to jnelson993)
Post #: 8
RE: Creating New report to detail what Games are installed - 5/9/2008 3:17:13 PM   
sconnell

 

Posts: 47
Score: 0
Joined: 7/6/2007
Status: offline 		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.

(in reply to sconnell)
Post #: 9
RE: Creating New report to detail what Games are installed - 5/9/2008 4:49:09 PM   
jnelson993


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		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.

_____________________________

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

(in reply to sconnell)
Post #: 10
RE: Creating New report to detail what Games are installed - 5/9/2008 4:53:29 PM   
jnelson993


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		http://myitforum.com/cs2/blogs/socal/archive/2007/05/12/sms-2003-sp3-upgrade-checklist.aspx

_____________________________

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

(in reply to jnelson993)
Post #: 11
RE: Creating New report to detail what Games are installed - 5/9/2008 8:23:00 PM   
sconnell

 

Posts: 47
Score: 0
Joined: 7/6/2007
Status: offline 		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?

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


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		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.


_____________________________

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

(in reply to sconnell)
Post #: 13
RE: Creating New report to detail what Games are installed - 5/14/2008 10:34:15 AM   
bwoodall

 

Posts: 18
Score: 0
Joined: 5/6/2008
Status: offline 		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

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


Posts: 596
Score: 67
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		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



_____________________________

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

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

 

Posts: 18
Score: 0
Joined: 5/6/2008
Status: offline 		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 


< Message edited by bwoodall -- 5/14/2008 11:33:43 AM >

(in reply to jnelson993)
Post #: 16
RE: Creating New report to detail what Games are installed - 5/14/2008 11:36:14 AM   
gjones


Posts: 599
Score: 41
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		Those version number mean you are SP2.

_____________________________

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/blog/gjones/


(in reply to bwoodall)
Post #: 17
RE: Creating New report to detail what Games are installed - 5/14/2008 11:45:48 AM   
bwoodall

 

Posts: 18
Score: 0
Joined: 5/6/2008
Status: offline 		OK I see says the blind man. Only the Admin UI is on SP3. I will begin the upgrade process after reviewing the checklist.

(in reply to gjones)
Post #: 18
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> Web Reporting >> Creating New report to detail what Games are installed Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

0.313