I'd be interested in the last patch date as well. I think that'd be a useful
statistic to hand over to the security team when they ask for patch status and
could be used in tracking down clients that haven't been patched since x date
to help obtain 100% compliance. I know there are other ways to go about that
but having a last reboot and last patch date in one report seems pretty handy
to me.
Surajit, here's the query I use for showing their last reboot date. You can
uncomment the first 'where' statement if you want to only show machines that
haven't rebooted over a specific number of days. Hope that helps.
Select
SD.Name0 'Asset Tag',
SD.User_Name0 as 'User ID',
USR.Full_User_Name0 as 'Full Name',
Convert(VarChar(10), OS.LastBootUpTime0, 101) 'Last Boot Date',
DateDiff(D, OS.LastBootUpTime0,
GetDate()) 'Days Since Boot'
>From v_R_System SD
Join v_Gs_Operating_System OS on SD.ResourceID = OS.ResourceID
Join v_R_User USR on SD.User_Name0 = USR.User_Name0
Where --(DateDiff(D, OS.LastBootUpTime0, GetDate()) >= 60) and
SD.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.1'
Order By OS.LastBootUpTime0
From: [email protected] [mailto:[email protected]] On
Behalf Of Garth Jones
Sent: Wednesday, April 23, 2014 8:14 AM
To: [email protected]
Subject: [mssms] RE: Last patch and last reboot date
Ok, I will bite, why do you care about the date of the last Software Update
that was installed? How will that be useful information at all?
Garth Jones
Chief Architect
www.Enhansoft.com<http://www.enhansoft.com/>
[Description: Description:
cid:[email protected]]<http://www.enhansoft.com/>
Enhancing Your Business
[Description: Description: Description: Description: Description: Description:
Description:
cid:[email protected]]<http://be.enhansoft.com/>[Description:
Description: Description: Description: Description: Description: Description:
cid:[email protected]]<https://twitter.com/enhansoft>[Description:
Description: Description: Description: Description: Description: Description:
cid:[email protected]]<http://www.facebook.com/EnhansoftInc>[Description:
Description: Description: Description: Description: Description: Description:
Description: Description: Description: Description: Description: Description:
Description: Description: Enhansoft's YouTube
Page]<http://www.youtube.com/user/Enhansoft/videos>[Description: Description:
Description: Description: Description: Description: Description:
cid:[email protected]]<http://myitforum.com/myitforumwp/community/groups/enhansoft/>
See us at booth #1240<http://northamerica.msteched.com/#fbid=poJHUxb29bD>
[TechEdExhibitor Button]<http://northamerica.msteched.com/#fbid=poJHUxb29bD>
Ask Me About Our Free SSRS
Reports<http://www.enhansoft.com/pages/Free-SSRS-Reports.aspx>
From: [email protected]<mailto:[email protected]>
[mailto:[email protected]] On Behalf Of Mukherjee, Surajit
Sent: Wednesday, April 23, 2014 5:05 AM
To: [email protected]<mailto:[email protected]>
Subject: [mssms] Last patch and last reboot date
I would like to generate a report of last patch date and last reboot date\time
for all systems. Is there any query which gives such output in SCCM report?
Also is there any way to find client's service status after reboot by using
query?
Thanks in advance,
Surajit
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the intended recipient, please: (i) delete the message and all
copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii) notify the sender immediately. In addition, please be aware that any
message addressed to our domain is subject to archiving and review by persons
other than the intended recipient. Thank you.
________________________________
IRS Compliance: Any tax advice contained in this communication (including any
attachments) is not intended or written to be used, and cannot be used, for the
purpose of (i) avoiding penalties imposed under the Internal Revenue Code or
applicable state or local tax law or (ii) promoting, marketing, or recommending
to another party any transaction or matter addressed herein.
________________________________
Confidentiality Notice: This e-mail is intended only for the addressee named
above. It contains information that is privileged, confidential or otherwise
protected from use and disclosure. If you are not the intended recipient, you
are hereby notified that any review, disclosure, copying, or dissemination of
this transmission, or taking of any action in reliance on its contents, or
other use is strictly prohibited. If you have received this transmission in
error, please reply to the sender listed above immediately and permanently
delete this message from your inbox. Thank you for your cooperation.
