Solved

problem with collection in SCCM

Posted on 2010-09-16
1
552 Views
Last Modified: 2012-05-10
Hi,

I am trying to create a collection that contains all the machines in my company that have autocad 2006 LT installed. I am doing this by querying the add/remove attribute.

here is the sql :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceId = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = "AutoCAD LT 2006 - English"


Can anyone help?

Cheers
0
Comment
Question by:chqshaitan
1 Comment
 
LVL 31

Accepted Solution

by:
merowinger earned 250 total points
ID: 33805701
Ok so what's the problem. The query looks good.

Try to execute the followinf query directly on your SQL Server:
SELECT Name0,DisplayName0
      ,InstallDate0
      ,Publisher0
      ,Version0
  FROM [SMS_CM1].[dbo].[v_Add_Remove_Programs]
Inner Join v_R_System on (v_R_System.ResourceID = v_Add_Remove_Programs.ResourceID)
Where DisplayName0 = 'AutoCAD LT 2006 - English'


If no result are returned than the application is maybe listed with another DisplayName. The Try the following
...
Where DisplayName0 Like '%AutoCAD%'
...
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question