Client Management Suite

 View Only
  • 1.  How can I target the computers where the primary user is in a specific department?

    Posted Oct 08, 2010 10:44 AM

    Just as the title says...

    For some software deployment, I need to target the machines where the machine's primary user is in a specific department.  I can see all the user department information under Resources, but am not sure how to pull PCs from that.



  • 2.  RE: How can I target the computers where the primary user is in a specific department?

    Posted Oct 08, 2010 10:56 AM

    You would need to determine that, and then setup a resource association between computers and departments. Or even users and departments. With the primary user, the PC to User association is already established, so you need to 'complete the circle'.



  • 3.  RE: How can I target the computers where the primary user is in a specific department?

    Posted Oct 08, 2010 11:17 AM

    The user's department gets populated from an Altiris AD Import.



  • 4.  RE: How can I target the computers where the primary user is in a specific department?

    Posted Oct 08, 2010 03:21 PM

    Hi Zac,

    You can try creating a sql based filter by joining the dbo.vuser and dbo.Inv_AeX_AC_Primary_User.  The only thing not sure if user is the same as name in the two tables...  i.e.

    select a1._ResourceGuid, i.name from (select name, domain from dbo.vuser where department like 'departmentname') aduser

    JOIN dbo.Inv_AeX_AC_Primary_User a1 on aduser.name = a1.[user]

    JOIN dbo.vitem i on a1._ResourceGuid = i.guid

    WHERE a1.[Month] = datename(month,dateadd(mm,0,getdate()))



  • 5.  RE: How can I target the computers where the primary user is in a specific department?

    Posted Oct 08, 2010 04:07 PM

    Wow.  That's awesome.  I'll try that on Monday.  Some day I'll get my head wrapped around SQL queries...