Jump to content


GarthMJ

Moderators
  • Posts

    1949
  • Joined

  • Last visited

  • Days Won

    93

Posts posted by GarthMJ

  1. Each Month Enhansoft gives away a free SCCM dashboard / report. 

    Total_Usage_Trend_Analysis_for_Collectio

    November's Free Report is... 

    Total Usage Trend Analysis for Collections! This software metering dashboard gives you results for all applications and will display these details for up to four collections. The results are grouped by month and will go back as far as what is stored in your SCCM environment (usually 9-months to a year).

    Get your free report today! The Total Usage Trend Analysis for Collections report is only available in November.

  2. 6 hours ago, kaiserclaw said:

    This is what I got so far:

    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.ProdID like "{34624CAC-1434-468E-56DC-2A7D44D5F49F}" and SMS_R_System.SecurityGroupName != "MGT\\App-install-Adapt"
     

     

    You will need to use a sub-select query to do the not in stuff. 

    Here is an example. https://www.enhansoft.com/blog/subselect-wql-query-to-find-pcs-that-do-not-have-either-x86-or-x64-versions-of-software-installed

    • Like 1
  3. Did you create a SWM rule for spotify? When did you create this rule? Is the Software listed in Installed Programs in resource explorer? Is the SW installed under the user content? if it is installed under the user context then you will need a 3rd party tool to collected this information with SCCM. 

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.