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.  

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;