Forum Discussion

Will_Restore's avatar
9 years ago

Stale information from query

Updated a bunch of clients to NetBackup 7.7.2 and then ran this query to see which might have been missed.  It's showing most of the updated clients as older version.  Also lists some clients which were decommissioned years ago. Is there a way to refresh OpsCenter? 

 

SELECT name, versionLabel

FROM domain_Client;

 

  • I stopped Data Collection for all servers then restarted and it fixed some of the report data but no means all of it. 

  • What about this

    SELECT name, versionLabel
    FROM domain_Client
    where DATEDIFF(day,UtcBigIntToNomTime(lastUpdatedTime), GETDATE()) <= 2