SOLVED WQL Query get last logon computer name

[tata789]

Hello
I created USER based collection and working fine, now I need WQL Query to get last logon computer name from user based collection
and I try but not working I get no list user id is with one letter and number like A000356
please help

thank you
AK

 

[Garth]

OK, I will bite, why do you want to do that, particularly as a collection?

 

[tata789]

place I work I can deploy app to the user group but client doesn't like to do it and they give me user id and ask to get last logon computer name so can deploy the app,
I try to run WQL query and did not work, may be my Query wrong, that is why I need

thank you
AK

 

[Garth]

Last logon is a bad idea as this allow the SW to be install on any computer! What you want is primary user instead and you want to deploy to user group with the flag to only install on primary devices. Thsi will only allow the sw to be install on computer where the user is marked as the primary user.

 

[Garth]

I try to run WQL query and did not work, may be my Query wrong, that is why I need

The query that you are trying to write will be almost impossible to write. if it is possible it will not be a simple query to write.

 

[tata789]

ok, you saying not doable , if so can you advise what to do, how I can get last logon computer name?
thank you
AK

 

[Garth]

ok, you saying not doable , if so can you advise what to do, how I can get last logon computer name?

Getting the last logon user is easy. Mixing user and computer collects is hard.

There is no trick to getting last logon user in a device query, just select it from the query wizard.

 

[tata789]

will do
thank you
AK