locked
Computers with Specific software installed +++ Primary User RRS feed

  • Question

  • I am wondering if anyone has a report for all machines with a specific product and the the primary user of that machine. 

    ~Joshua

    Friday, April 1, 2016 5:46 PM

Answers

  • I have only found one report that gets 90% of that I am looking for which is the 

    "Computers with specific software registered in Add Remove Programs.


    ~Joshua

    Dear Sir,

    Do you mean that it does not have Primary User? Then you can make a copy and customize it just join UPM view.

    Select DISTINCT sys.Netbios_Name0, fcm.SiteCode,  sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0 ,usr.username AS PrimaryUser 
    FROM fn_rbac_R_System(@UserSIDs)  sys
    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID 
    JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
    Join v_UsersPrimaryMachines UPM on sys.ResourceID = upm.MachineID
    join v_Users Usr on upm.UserResourceID = usr.UserID
    WHERE DisplayName0 like @filterwildcard and fcm.CollectionID=@CollID

    Best regards

    Frank


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com


    • Edited by Frank Dong Saturday, April 2, 2016 8:09 AM
    • Proposed as answer by Frank Dong Thursday, April 14, 2016 8:47 AM
    • Marked as answer by Frank Dong Monday, May 9, 2016 9:38 AM
    Saturday, April 2, 2016 8:08 AM

All replies

  • Have you looked at the built-in reports for this?

    Garth Jones

    Blog: http://www.enhansoft.com/blog Old Blog: http://smsug.ca/blogs/garth_jones/default.aspx

    Twitter: @GarthMJ Book: System Center Configuration Manager Reporting Unleased

    Friday, April 1, 2016 6:09 PM
  • I have only found one report that gets 90% of that I am looking for which is the 

    "Computers with specific software registered in Add Remove Programs.


    ~Joshua

    Friday, April 1, 2016 6:33 PM
  • Good Day
    Please try under Asset Management
    Software 02D - Computers with specific software installed

    Regards


    Friday, April 1, 2016 6:55 PM
  • I have only found one report that gets 90% of that I am looking for which is the 

    "Computers with specific software registered in Add Remove Programs.


    ~Joshua

    Dear Sir,

    Do you mean that it does not have Primary User? Then you can make a copy and customize it just join UPM view.

    Select DISTINCT sys.Netbios_Name0, fcm.SiteCode,  sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0 ,usr.username AS PrimaryUser 
    FROM fn_rbac_R_System(@UserSIDs)  sys
    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID 
    JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
    Join v_UsersPrimaryMachines UPM on sys.ResourceID = upm.MachineID
    join v_Users Usr on upm.UserResourceID = usr.UserID
    WHERE DisplayName0 like @filterwildcard and fcm.CollectionID=@CollID

    Best regards

    Frank


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com


    • Edited by Frank Dong Saturday, April 2, 2016 8:09 AM
    • Proposed as answer by Frank Dong Thursday, April 14, 2016 8:47 AM
    • Marked as answer by Frank Dong Monday, May 9, 2016 9:38 AM
    Saturday, April 2, 2016 8:08 AM