I think..but I can't confirm; check in select * from v_userMachineTypeRelation;
there's a 'type' in there. I don't remember for sure, but I think the diff
values mean diff things, like assigned by usage, created by a script, created
by the user saying so locally; that kind of thing. I don't know if that
particular info is in an SMS_ wmi class where you can make it part of a
collection query--I never looked.
On Thursday, April 16, 2015 3:10 PM, "Beardsley, James"
<[email protected]> wrote:
<!-- _filtered #yiv4717264856 {font-family:"Cambria Math";} _filtered
#yiv4717264856 {font-family:Calibri;} _filtered #yiv4717264856
{font-family:Catriel;}#yiv4717264856 p.yiv4717264856MsoNormal, #yiv4717264856
li.yiv4717264856MsoNormal, #yiv4717264856 div.yiv4717264856MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv4717264856 a:link, #yiv4717264856
span.yiv4717264856MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv4717264856 a:visited,
#yiv4717264856 span.yiv4717264856MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv4717264856
span.yiv4717264856EmailStyle17
{font-family:Catriel;color:#1F4E79;font-weight:normal;font-style:normal;text-decoration:none
none;}#yiv4717264856 .yiv4717264856MsoChpDefault {font-family:"Calibri",
sans-serif;} _filtered #yiv4717264856 {margin:1.0in 1.0in 1.0in
1.0in;}#yiv4717264856 div.yiv4717264856WordSection1 {}-->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 GroupDixon Hughes Goodman LLP
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.
