It is in the database so is retrievable

Craig pointed the base logic in one post for retrieving data

and then figured out the needed query for this in another post.

I saw mention that if you have ZRS this is easy.  I do have a Zenworks Reporting Server setup but still am not finding how to get a report showing the "reboot pending since" and "reboot required" information.  

Having asked before, there is Not a way within normal ZENWorks reporting options.  That would be a great Idea.

One needs to do that direct DB query that those links describe, as Craig figured it out. 

This prompted me to write them up a bit cleaner as follows.

If you are using the ZCM internal DB, then you can use DBeaver for your queries  Just grab the Free Community Edition
and then follow KM000001612   to configure it.

  For the other DBs you'd likely best be using their tools, and if you made such a choice, largely have the skills to map this out on it.

Then perform the following query:

select zdeviceex.rebootpendingsince rebootpendingsince , zzenobject.path from zdeviceex join zzenobject on zzenobject.zuid=zdeviceex.zuid order by rebootpendingsince asc;

Thank you for your explanation.  I was able to install DBeaver and run the query as you and Craig described.  Unfortunately, it is not very helpful since the date doesn't show up in a meaningful formant.  (I saw your notes about maybe creating script to convert, etc. but that is way more work than I have time to invest).  

So far, I have been very disappointed with Zenworks patch management in that it does not provide any user friendly means of tracking, reporting, or doing any sort of follow up on needed patches.  I do have Zenworks Reporting Server setup and have looked through the patch reports provided but they don't really help much in trying to find and update devices that are not up to date (ie maybe just need a reboot). 

atobias said:

the date doesn't show up in a meaningful formant

Could you post an example?

for one client I have the most recent needs to reboot of
   2024-08-26 18:22:14.000
this being at 14:39 EDT,   so this tells me they are saved in UTC times.

with all the ones that aren't pending a reboot showing   [NULL]

For example, the report shows 22:47.0 for device FTWD025  

But in ZCC the Reboot Pending since shows date and time I can understand. 

For example, the report shows 22:47.0 for device FTWD025  

But in ZCC the Reboot Pending since shows date and time I can understand. 

hmm,  missing the date. 

     but the time makes perfect sense to me
5PM In EDT is 1700 EDT in 24hour time,  and therefor 2200 in UTC 24hour time.
    Of course assuming you are also in EST/EDT timezone as other evidence suggests.

I am suspecting it is a data display issue that is not showing the date.   Poking at my instance of DBeaver

All I can think of is having missed one of the settings in the
   Select Window / Preferences /  Editors / Binary Editor /
portion may cause it to not show the date.

If the DB or MSSQL or Oracle...Maybe use one of their query tools...I'm guessing the Date Format is just not returning clearly by default.

You can query right in the ZCC for any device with a reboot pending since a given date...

Thanks to both of you for your help.  I believe I'll be able to get what I'm looking for now.