Forums on Intune, SCCM, and Windows 11

Welcome to the forums. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your topics and posts, as well as connect with other members through your own private inbox!

PENDING Query based prompt AND allow user text?

SCCMBoss

New Member
Messages
2
Reaction score
0
Points
1
In the SCCM 2007 Config Mgr console, you can create and run a report regarding "like" software and enter "Adobe%", then click on the values button and see a filtered list of all software that begins with "Adobe". I can select one of the listed names, or leave "Adobe%" and see all software that has a display name that begins with "Adobe".

We have a new SCCM current branch server that user SSRS (with a SQL server on the back end). Based on articles on this web site, I've been able to create a prompt for "Software Title" that will give me a query based list of software titles. However, I cannot filter the list and I cannot enter my own text in the field. This is the expected result b/c the online help tells me I cannot enter a value when the "Available values" are defined by a query.

What I'd like to know is if there's an alternative way to do this so I can have it both ways as we do in SCCM 2007.

I realize this is a fairly general question. Let me know if you need more details.
 
There are three possibilities:

  1. Use the default reports already existed on your SSRS : Monitoring => Reporting => Asset Intelligence => Software 02D - Computers with specific software installed
  2. Create a collation (computers) based on this query: (NOTE: Change "Your AV Program" with your Software (Adobe...).

    Code:
    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_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName = "Your AV Program"
    [/LIST]

  3. Create a new report using Report Builder (based on query SQL above).
 
Code:
select distinct sys.Name, sys.SMSAssignedSites, sys.OperatingSystemNameandVersion, sys.ResourceDomainORWorkgroup, sys.LastLogonUserName, sys.IPAddresses, sys.IPSubnets, sys.ResourceId, sys.ResourceType from  SMS_G_System_SoftwareProduct as prod inner join SMS_R_System as sys on sys.ResourceId = prod.ResourceID where prod.ProductName like ##PRM:SMS_G_System_SoftwareProduct.ProductName##
 

Forum statistics

Threads
7,025
Messages
27,490
Members
17,677
Latest member
Nairolf

Trending content

Back
Top