Jump to content


Established Members
  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About cantgetanythingtowork

  • Rank
  1. Sorry if I caused confusion I'm trying to do a user query. The query above returns all users who have logged on to a workstation where the software metering rule matches. It also returns devices but that is of no consequence now since I only need the user for the final result. However, only one of those relationships is active and thus I want the where-clause to get a singular username who I can then remove from the application deployment collection and deploy application uninstall. The applications are deployed initially with requirement that the device it is installed on is users pri
  2. Hello. I'm having trouble making up a query for software metering. The query was adopted from some site and then modified to suit my purposes. I am however having problems adding a simple where-clause to this query. The query is as follows: Select SMS_R_System.ResourceID,SMS_R_System.Name,SMS_R_User.UniqueUserName FROM SMS_R_System JOIN SMS_UserMachineRelationship ON SMS_R_System.Name=SMS_UserMachineRelationship.MachineResourceName JOIN SMS_R_User ON SMS_UserMachineRelationship.UniqueUserName=SMS_R_User.UniqueUserName INNER JOIN SMS_G_System_SoftwareFile ON SMS_G_System_SoftwareFile.Res
  • Create New...