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:


  


Add/Remove Programs dump for all computers in a collection

 
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 >> Add/Remove Programs dump for all computers in a collection Page: [1]
Login
Message << Older Topic   Newer Topic >>
Add/Remove Programs dump for all computers in a collection - 10/8/2008 2:59:29 PM   
enieft

 

Posts: 40
Score: 0
Joined: 5/17/2007
Status: offline 		I am looking to get a add/remove programs inventory on all computers in a specific collection or is this possible by querying by name (select all devices with name AB, AC and get add/remove inventory information).

Looking for a sql statement or suggestions.

Thanks,
Eric
Post #: 1
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 8:56:26 AM   
gjones


Posts: 824
Score: 50
Joined: 6/5/2001
From: Ottawa, Ontario, Canada
Status: offline 		try this http://smsug.ca/blogs/garth_jones/archive/2008/10/09/list-arp-by-pcs-with-name-like.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 enieft)
Post #: 2
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 12:04:51 PM   
enieft

 

Posts: 40
Score: 0
Joined: 5/17/2007
Status: offline 		what happens though if I dont have the view:  or should I be putting this query into sms rather than query analyzer?
dbo.v_Add_Remove_Programs


(in reply to gjones)
Post #: 3
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 12:16:46 PM   
jnelson993


Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		SMS 2003, right?  He's giving you valid SQL code (even if it does use v_GS_COMPUTER_SYSTEM instead of V_R_SYSTEM :) ... so what do you mean "don't have the view"  It's a view that comes with SMS...so unless you've deleted it, it's got to be there.  Are you sure the SMS db is the active DB?  Either select it from the top, or run:

USE SMS_XYZ
GO

(change SMS_XYZ to your SMS database name first) then run his query from query analyzer


_____________________________

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

(in reply to enieft)
Post #: 4
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 1:28:10 PM   
enieft

 

Posts: 40
Score: 0
Joined: 5/17/2007
Status: offline 		dbo.v_Add_Remove_Programs is the view that I cannot see.

Eric

(in reply to jnelson993)
Post #: 5
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 1:36:45 PM   
gjones


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

SELECT
ARP.ProdID0,
ARP.DisplayName0,
ARP.Version0,
CS.Name0
FROM
dbo.v_GS_ADD_REMOVE_PROGRAMS ARP,
dbo.v_GS_COMPUTER_SYSTEM CS
WHERE
ARP.ResourceID = CS.ResourceID
AND CS.Name0 Like 'AB%'

_____________________________

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 enieft)
Post #: 6
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 2:08:59 PM   
enieft

 

Posts: 40
Score: 0
Joined: 5/17/2007
Status: offline 		cool that worked.  Now what I was looking for was a full list rather than each pc seperate,  however it's an easy fix in excel to get this information.

Thanks again folks!

Eric

(in reply to gjones)
Post #: 7
RE: Add/Remove Programs dump for all computers in a col... - 10/9/2008 2:45:21 PM   
jnelson993


Posts: 899
Score: 127
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline 		One little caveat, that view is for 32-bit machines only.  If you have any x64 machines, they won't be represented by that view...that's why the dbo.v_Add_Remove_Programs view is handy.

So perhaps, just do this to get the 32-bit AND 64-bit data together

SELECT
   arp.ProdID0,
   arp.DisplayName0,
   arp.Version0
FROM
   dbo.v_GS_Add_Remove_Programs ARP
WHERE
   arp.resourceID IN (SELECT ResourceID FROM dbo.v_FullCollectionMembership WHERE CollectionID = @CollectionID)
UNION
SELECT
   arp.prodID0,
   arp.DisplayName0,
   arp.Version0
FROM
   dbo.v_GS_Add_Remove_Programs_64 arp
WHERE
   arp.resourceID IN (SELECT ResourceID FROM dbo.v_FullCollectionMembership WHERE CollectionID = @CollectionID)
ORDER BY
   DisplayName0    

_____________________________

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

(in reply to enieft)
Post #: 8
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Add/Remove Programs dump for all computers in a collection 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

1.049