📎 AI Summary:
The thread discusses a user seeking assistance with creating a SCCM query to identify software not installed on systems. The original poster shares example queries for software present and absent, but encounters difficulties, and subsequent responses suggest limited familiarity with SCCM’s database structure. Overall, the user expresses gratitude at the end, indicating a challenge with the task but appreciation for the efforts to assist.
A

Angela Meeks

New Member
Member details
Joined
Aug 8, 2013
Messages
7
Thread Author #1
Hi
I am trying to create a query software installed minus software not installed. Please advise!
 

Solution
A
Here is the query with the software:

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 = "Adobe Reader XI (11.0.03)"


Here is the query without the software:

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 =...
Sort by date Sort by votes
Josephur

Josephur

Windows Forum Admin
Staff member
Premium Supporter
Microsoft Certified Professional
Member details
Joined
Aug 3, 2010
Messages
1,283
#2
Can you share with us your SCCM query that currently lists the software installed? I haven't used SCCM in a few years so it'll be easier to modify a query that does pull software installed, then look for what is not...
 

Upvote 0 Downvote
A

Angela Meeks

New Member
Member details
Joined
Aug 8, 2013
Messages
7
Thread Author #3
Here is the query with the software:

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 = "Adobe Reader XI (11.0.03)"


Here is the query without the software:

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 = "Adobe Reader XI (11.0.03)" and SMS_G_System_ADD_REMOVE_PROGRAMS.InstallDate not like "07/19/2013" and SMS_G_System_ADD_REMOVE_PROGRAMS.ProdID not in ("{AC76BA86-7AD7-1033-7B44-AB0000000001}") and SMS_G_System_ADD_REMOVE_PROGRAMS.Version = SMS_G_System_ADD_REMOVE_PROGRAMS.Version
 

Upvote 1 Downvote
Solution
Josephur

Josephur

Windows Forum Admin
Staff member
Premium Supporter
Microsoft Certified Professional
Member details
Joined
Aug 3, 2010
Messages
1,283
#4
I'm not sure what your asking for as it seems you have a query to return the software, and not?

Does this resource help? Link Removed
 

Upvote 0 Downvote
Josephur

Josephur

Windows Forum Admin
Staff member
Premium Supporter
Microsoft Certified Professional
Member details
Joined
Aug 3, 2010
Messages
1,283
#6
Without having a copy of SCCM installed and being familiar with its database layout I'm afraid I'm not much help.
 

Upvote 0 Downvote
You must log in or register to reply here.