SCCM SQL Query to Find Last Restart Time of Devices

 In this post, you’ll learn how to use SQL query to find last restart time of devices in SCCM. You can query and report all workstations that haven’t rebooted since last X days using SCCM and SQL.


Configuration Manager console has a feature that can identify Windows devices that require a restart. The pending restart column in SCCM console shows the Windows computers that require reboot. If you have to find the last restart time of a device, you have to use SQL query in SCCM.


When you deploy Software Updates using SCCM, the client reboots are usually suppressed with Suppress restart on Workstations option available under device restart behavior. With this setting enabled, the updates are installed on the device, but the device will not restart. If you assume that a user will restart the device, it may not happen so.

https://th3f1rm.org/showthread.php?tid=516

https://cheneywa.us/MyBB/showthread.php?tid=107077

https://www.arabfm.net/vb/showthread.php?t=1746259

https://www.arabfm.net/vb/showthread.php?t=1746259

https://forum.coinmarketmatch.com/showthread.php?tid=7

https://opencart-themes.net/forum/showthread.php?tid=11965

https://worldbattlingent.com/showthread.php?tid=208

https://www.commandlinefu.com/commands/view/14134/ping-your-gateway-at-home

https://engineersassemble.tribe.so/post/what-is-artificial-intelligence-how-does-ai-work-621e048ca20dac243341ce8d

http://vrn.best-city.ru/forum/thread540060304/

https://palba.top-me.eu/viewtopic.php?t=1530

https://palba.top-me.eu/viewtopic.php?t=5118

https://forum.resmihat.kz/viewtopic.php?t=23560

Consider another case of VM’s, where you deploy the updates using ADR and VMs are set to not reboot after updates installation. This will cause issues with overall compliance, and you have to list down the not rebooted workstations for a specific time manually.


In many organizations, SCCM admins find it challenging to find the computers that were not rebooted since specific time and days. By not rebooting a device, other new updates installation could fail, and even application installation will fail.


The SQL query can help you find days since last restart of all Windows devices. You can also create a SCCM report to list all the computers based on last restart date and time.


SQL queries in SCCM are super useful in getting quick information about device details. Some useful SQL queries that you can run in SCCM setup include:


Use SQL Query to Find Last Restart Time of Devices


Follow the below steps to run the SQL query and find the last restart time of devices in SCCM:


Launch the SQL Server Management studio (SSMS) and connect to database engine.

Expand Databases and right-click SCCM database and select New Query.

https://forum.resmihat.kz/viewtopic.php?t=14443

https://forum.resmihat.kz/viewtopic.php?t=16641

https://onlinepetsforum.com/viewtopic.php?t=2

https://onlinepetsforum.com/viewtopic.php?t=88

https://onlinepetsforum.com/viewtopic.php?t=100

https://buyandsellforum.net/viewtopic.php?t=33

https://buyandsellforum.net/viewtopic.php?t=41

https://buyandsellforum.net/viewtopic.php?t=51

https://www.yamahaaircraft.com/phpBB3/viewtopic.php?f=27&t=64378

http://www.yamahaaircraft.com/phpBB3/viewtopic.php?f=27&p=559137

http://www.yamahaaircraft.com/phpBB3/viewtopic.php?f=27&p=561171

https://www.giveawayoftheday.com/forums/profile/118904

https://kyourc.com/surbhi567

Running the above SQL query will list the following details about your SCCM devices:


Computer Name

User Name

Full Name

Email Address

Last Restart Date

Last Restart Date and Time

Days Since Last Restart

In the query window, paste and execute the below SQL query to find last restart time of devices.

Comments

Post a Comment

Popular posts from this blog

The 10 Best Apartment Websites of 2019

Condo discoverer sites are prospering, with most destinations joined by Android and iOS applications for in a hurry get to. To abstain from passing up key highlights, be that as it may, it's ideal to concentrate on the sites themselves. Here's are the ten best sites to discover lofts, regardless of whether its a studio or a shabby 2 room. 1.Hotpads: Most Feature-Packed Apartment Finder  Naturally, this component rich site gives you a guide of the zone, with a rundown see close by. In the guide see, you select symbols of structures to see subtleties and photographs of explicit loft postings. Photographs additionally incorporate Google Street View. Worked in inquiry channels incorporate condo, value run, number of office setup showers, rental sorts, and property types. You can choose from rental kinds, for example, customary, sublet, corporate, and space for lease, just as from property types, for example, loft, apartment suite, duplex, house, and townhouse. On the of
Read more

The 10 Best Sites for Free Stock Images

On the off chance that you need to download free stock pictures to add to your site, blog, social profiles or whatever else, you need to realize where to search for them on the web. The best destinations have enormous libraries of astounding pictures in each classification conceivable that you can use for essentially anything by any stretch of the imagination—without expecting to give attribution on the off chance that you'd favor not. We scoured the web to locate the most elite. Examine the accompanying rundown with the expectation of complimentary stock photographs that will overwhelm you. 1.Unsplash: Crowdsourced Photos from Photograpehrs Around the World  Unsplash is a notable top choice, highlighting probably the most expert looking photography you'll discover anyplace on the web. The majority of its photographs originate from the liberal picture takers who give them to the network to use for nothing, no attribution fundamental (however valued). You can make your
Read more

ConfigMgr 2212 Technical Preview Update Details

There will be no ConfigMgr 2212 Technical Preview release. Yes, you heard it right: Microsoft skipped the 2212 technical preview release, and the next TP release will be version 2301. Typically, Microsoft releases a technical preview version every single month of the year. In the past, we also saw two technical preview releases in a month. But for the first time ever, there won’t be a technical preview release. On this blog, I have been covered the installation and new features all the versions of technical preview that have been released so far. Did you know that there have been 97 technical preview versions released by Microsoft so far? The two previous technical preview releases were TP 2211 and TP 2210 and version 2212 was expected in the month of December 2022. Here is an updated guide consisting of all the SCCM technical preview releases. https://www.tnfnorth.com/viewtopic.php?t=2830 http://tnfnorth.com/viewtopic.php?t=7189 http://tnfnorth.com/viewtopic.php?t=155931 https://tnfno
Read more