Strange behavior for CMPivot

Question

In the past few days, I learned that a CMPivot query will return cached results from the last hardware inventory scan stored in the site database for offline clients. This is correct when I run a CMPivot query to get Operating System, Physical lDisk or Physical Memory etc, I can get the reports for both online and offline clients. But for some other properties, for example BIOS and InstalledSoftware, I can ONLY get a blank result, it will not show anything for offline clients.

Strange! It seems that some CMPivot query properties use stored data in the site database, but the others do not. Can someone explain its mechanism?

Answer 1

Hi,

I hope you are doing well.

Yes, your observation is correct. I have also obtained the same results as yours in my lab. In fact, the result is hidden in the welcome page of CMPivot.

When we open CMPivot tool, we see the home page of CMPivot firstly. Within the home page, the list of Entities contains items which are underlined / clickable links and items that are not underlined / not clickable. Underlined items indicate that you can only query for that Entity on online devices in real-time. Non-underlined / not clickable Entities indicate that you can query against Hardware Inventory even for offline devices (query results are light gray text), but for online devices (results are black text) you will get real-time query results as well. At the same time, it updates the results if necessary with live data from any online clients.

As BIOS and InstalledSoftware entities are underlined, so they will not use the data stored in site database and only query for online devices in real-time.

CMPivot, Run Script, & Client Notification (Again!)

Note: This is non-Microsoft link, just for your reference.

Should you have any questions or concerns, please do feel free to contact me.

Best regards,

Simon

---

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

I have not any problem.My answer it is. When any problems will come, I shall solve the problem. Man is the best create of God. So, know thyself and need to more learn. Try and do both will give successes. Answered by TUKU. mdataurrahmank519@gmail.com