current time for CMPIVOT?

Question

Good Afternoon Team.

Wishing you a happy new year.

Can I by cmpivot have the way to know the current time of a device?

I'm looking but can't find the specific query.

Thank you for your help.

Answer 1

@Rafael Aguilar
Hi,
We tried to get the current time of the device through CMPIVOT, but we did not find a specific query to get the current time of the device directly. We found an indirect query method to get the current time of the device.
You may try the following query: ComputerSystem. The current time of the device can be calculated from the Current Time Zone according to UTC. The specific screenshot is as follows:

---

If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

BTW, in theory you can do this using the script feature and powershell.