But instead of sccm any way to get from AD using scripts On Friday, December 2, 2016, Daniel Ratliff <dratl...@humana.com> 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 | dratl...@humana.com > <javascript:_e(%7B%7D,'cvml','dratl...@humana.com');> > > > > *From:* listsad...@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','listsad...@lists.myitforum.com');> [mailto: > listsad...@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','listsad...@lists.myitforum.com');>] *On > Behalf Of *Daniel Ratliff > *Sent:* Friday, December 02, 2016 10:52 AM > *To:* ms...@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','ms...@lists.myitforum.com');>; > scripting@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','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 > <javascript:_e(%7B%7D,'cvml','listsad...@lists.myitforum.com');> [ > mailto:listsad...@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','listsad...@lists.myitforum.com');>] *On > Behalf Of *Kevin Ray > *Sent:* Friday, December 02, 2016 10:41 AM > *To:* mssms <ms...@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','ms...@lists.myitforum.com');>>; > scripting@lists.myitforum.com > <javascript:_e(%7B%7D,'cvml','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. > >