cancel
Showing results for 
Search instead for 
Did you mean: 

How to Fecth the client info

Aris56
Level 4

 

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions

M_henriksen
Level 4
Partner

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'

View solution in original post

4 REPLIES 4

M_henriksen
Level 4
Partner

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'

RiaanBadenhorst
Moderator
Moderator
Partner    VIP    Accredited Certified

Post your query and we'll see what is wrong.

Aris56
Level 4

 

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.

 

M_henriksen
Level 4
Partner

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