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

How to get Amazon Prime for free for Prime Day

 At the point when Amazon's Prime Day begins Tuesday, October 13 at 12 a.m. Pacific, you'll should be a Prime part to participate in the arrangements. Prime is Amazon's $119 every year administration that gives two-day delivering on all requests, just as a huge amount of additional items like the Kindle loaning library and Prime Video.  Uplifting news, however: You shouldn't pay for participation at all in the event that you simply need it sufficiently long to exploit Amazon's yearly shopping spectacle. Here are a couple of approaches to get a transient Prime enrollment to capitalize on the reserve funds.  Technique One: The standard 30-day free preliminary  In the event that you've never attempted Amazon Prime or haven't attempted it in some time, you might be qualified for a free, 30-day preliminary. After the 30 days, Amazon will charge you for the participation—either $13 every month or $119 every year—so remember to drop before the preliminary is done. ...
Read more