12-08-2015 12:49 AM
Hi,
Does anyone can share the SQl query to get the client info such as below:
- Master server
- Host (client name)
- Operating system
- OS type
- Host type
- Version
- Status
i followed this link but when i ran the query, it will stuck at loading and eventually crashed.
https://www.veritas.com/community/forums/opscenter-analytic-generate-all-client-report
Please advise.
Thanks.
Solved! Go to Solution.
12-09-2015 03:40 AM
Hi, you can try this one
SELECT
DM.friendlyName as 'Master Server',
DC.Name AS "Client",
lookup_OS.name AS "OS Type",
DC.versionLabel AS "Client Version"
FROM "domain_client" DC, "domain_masterserver" DM, lookup_OS
WHERE DC.masterServerId = DM.id and
DC.osType = lookup_OS.id and
DC.isActive = '1'
12-09-2015 03:40 AM
Hi, you can try this one
SELECT
DM.friendlyName as 'Master Server',
DC.Name AS "Client",
lookup_OS.name AS "OS Type",
DC.versionLabel AS "Client Version"
FROM "domain_client" DC, "domain_masterserver" DM, lookup_OS
WHERE DC.masterServerId = DM.id and
DC.osType = lookup_OS.id and
DC.isActive = '1'
12-09-2015 08:41 PM
Post your query and we'll see what is wrong.
12-10-2015 06:00 PM
Hi Henri,
the command works. thanks.
but it seems to also list out the clients that have been removed from netbackup too.
But it works so, its okay.
thanks again.
12-18-2015 12:23 AM
Try this.. It looks 7 days back
SELECT
DM.friendlyName as 'Master Server',
DC.Name AS "Client",
lookup_OS.name AS "OS Type",
DC.versionLabel AS "Client Version"
FROM "domain_client" DC, "domain_masterserver" DM, lookup_OS
WHERE DC.masterServerId = DM.id and
DC.osType = lookup_OS.id and
DC.isActive = '1' and
DATEDIFF(day,UtcBigIntToNomTime(DC.lastUpdatedTime), GETDATE()) <= 7