The properties you are looking for are not stored in the Computers AD record. You’d have to connect remotely to the device, if you do not want to use ConfigMgr.
You can probably use “LastLogonDate” from AD to approximate uptime, and active status. Last logged on user is not stored with the computer object in AD. From: [email protected] [mailto:[email protected]] On Behalf Of Kevin Ray Sent: Friday, December 2, 2016 11:34 AM To: [email protected] Cc: [email protected] Subject: [mssms] Re: powershell script to pull the machine last rebooted information from active directory But instead of sccm any way to get from AD using scripts On Friday, December 2, 2016, Daniel Ratliff <[email protected]<mailto:[email protected]>> wrote: 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 | [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> From: [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> [mailto:[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');>] On Behalf Of Daniel Ratliff Sent: Friday, December 02, 2016 10:52 AM To: [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');>; [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> 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: [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> [mailto:[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');>] On Behalf Of Kevin Ray Sent: Friday, December 02, 2016 10:41 AM To: mssms <[email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');>>; [email protected]<javascript:_e(%7B%7D,'cvml','[email protected]');> 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.
