Sorry, v_r_system not v_r_system_valid. Only active machines show up in v_r_system_valid.
Daniel Ratliff Technology Architect | Client Innovation Solutions | Information Technology Infrastructure (ITI) T 502.476.9976 | dratl...@humana.com<mailto:dratl...@humana.com> From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff Sent: Friday, December 02, 2016 10:52 AM To: ms...@lists.myitforum.com; scripting@lists.myitforum.com Subject: RE: [mssms] powershell script to pull the machine last rebooted information from active directory LastBootUpTime is stored in win32_operatingsystem in WMI or v_gs_operating_system in SQL. Last Logged on User name, check these. http://www.enhansoft.com/blog/where-to-find-user-name-data-in-configuration-manager-part-1 http://www.enhansoft.com/blog/where-to-find-user-name-data-in-configuration-manager-part-2 Machine status is under v_r_system_valid for inactive 0 or 1. Daniel Ratliff From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> [mailto:listsad...@lists.myitforum.com] On Behalf Of Kevin Ray Sent: Friday, December 02, 2016 10:41 AM To: mssms <ms...@lists.myitforum.com<mailto:ms...@lists.myitforum.com>>; scripting@lists.myitforum.com<mailto:scripting@lists.myitforum.com> Subject: [mssms] powershell script to pull the machine last rebooted information from active directory Hi All, I have 100 machines on text file and looking to get the last rebooted date , last logged on user name and machine status (like active or inactive) export to csv file Any help Kevin 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. 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.
