I've been using the collection query below to return all machines that have a primary user assigned via UDA and it appears that it's not accurate after further examination.
select * from SMS_R_System where SMS_R_System.ResourceId in (select resourceid from SMS_UserMachineRelationship where UniqueUserName is not null) It seems that it is returning all clients that have a user/machine relationship (ie: users of this device in the last 90 days) instead of only clients that have an actual assigned primary user. Is there another query I should be using for this? Thanks, James Beardsley | Firm Technology Group Dixon Hughes Goodman LLP [cid:8644FC49-D5C9-45AE-B387-04FAFC0CC7A5]<http://www.dhgllp.com/> ________________________________ Confidentiality Notice: This e-mail is intended only for the addressee named above. It contains information that is privileged, confidential or otherwise protected from use and disclosure. If you are not the intended recipient, you are hereby notified that any review, disclosure, copying, or dissemination of this transmission, or taking of any action in reliance on its contents, or other use is strictly prohibited. If you have received this transmission in error, please reply to the sender listed above immediately and permanently delete this message from your inbox. Thank you for your cooperation.
