I just ran a few queries to see whats out there. There are a lot of views with TimeStamp, I would test some of those.
System System Resource Workstation Status Client Status Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Matt Browne Sent: Tuesday, February 17, 2015 10:59 AM To: [email protected] Subject: [mssms] RE: Collection of machines online is last 1day? OK, Thanks. I was looking to create a collection (if anyone knows how to do that). From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Garth Jones Sent: 17 February 2015 14:49 To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Collection of machines online is last 1day? It is a report. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Matt Browne Sent: Tuesday, February 17, 2015 8:14 AM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Collection of machines online is last 1day? Yes, thanks Mathieu. Is that a report query or a collection query? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Nabil AIT HADDAD Sent: 17 February 2015 11:54 To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Collection of machines online is last 1day? Thanks Mathieu for your sharing ! Merci From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of LEROY Mathieu Sent: mardi 17 février 2015 12:14 To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: Collection of machines online is last 1day? I’m using this one to regroupe active clients SELECT S.Name0 as 'Computer Name', S.User_Name0 as 'User Name',Case when CS.ClientActiveStatus='1' then 'Active' When CS.ClientActiveStatus='0' then 'Inactive' end as 'Client Active Status' FROM v_R_System S inner Join v_CH_ClientSummary CS on S.ResourceId=CS.ResourceID I guess you can tweak it a little to get what you want Cordialement, Mathieu Leroy Consultant T : +33 3 28 02 53 57 ― M : +33 6 21 63 74 15 ― F : +33 3 28 02 53 06 24 rue Papin - BP 50488 - 59664 Villeneuve d'Ascq Cedex email : [email protected]― web : www.osiatis.com<http://www.osiatis.com/> [http://m.c.lnkd.licdn.com/media/p/5/005/03c/191/1260f51.png][Description : Description : Description : cid:[email protected]] De : [email protected]<mailto:[email protected]> [mailto:[email protected]] De la part de Matt Browne Envoyé : mardi 17 février 2015 11:15 À : [email protected]<mailto:[email protected]> Objet : [mssms] Collection of machines online is last 1day? Does anyone have an easy way of creating a collection of machines that have been online in the last 1 day? I’m trying to use “v_CH_ClientSummary.LastOnline” but this doesn’t appear to be visible to collection queries. Does anyone know another good way to do this? Thanks Matt Browne ________________________________ Information in this message is sent in confidence and is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, any use, distribution or copying of the information is strictly forbidden. Please notify the sender immediately by return email or telephone 01823 721400. If you received this email in error please delete it and any copies of it from your system. Viridor Waste Management Limited Registered Office: Peninsula House, Rydon Lane, Exeter EX2 7HR Registered in England No. 575069 ________________________________ ________________________________ Information in this message is sent in confidence and is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, any use, distribution or copying of the information is strictly forbidden. Please notify the sender immediately by return email or telephone 01823 721400. If you received this email in error please delete it and any copies of it from your system. Viridor Waste Management Limited Registered Office: Peninsula House, Rydon Lane, Exeter EX2 7HR Registered in England No. 575069 ________________________________ ________________________________ Information in this message is sent in confidence and is intended only for the use of the individual or entity to whom it is addressed. If you are not the intended recipient, any use, distribution or copying of the information is strictly forbidden. Please notify the sender immediately by return email or telephone 01823 721400. If you received this email in error please delete it and any copies of it from your system. Viridor Waste Management Limited Registered Office: Peninsula House, Rydon Lane, Exeter EX2 7HR Registered in England No. 575069 ________________________________ The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
![http://m.c.lnkd.licdn.com/media/p/5/005/03c/191/1260f51.png][Description :](http://m.c.lnkd.licdn.com/media/p/5/005/03c/191/1260f51.png][Description :){kind=link}