cancel
Showing results for 
Search instead for 
Did you mean: 

Client Count Report

luisvidal
Level 5

Friends,

I do not know if I am missing something, but I could not find the type of report I need.

I am using OpsCenter 7.6.1.1 running on Windows Server 2012R2.

I need a report that will give me a list and count of the clients for a specific Master server on a given date (i.e. the list and count for clients backing up to Master A as of January 31, 2015).

 

Thanks in advance.

3 REPLIES 3

watsons
Level 6

Report Template -> Client Summary Dashboard -> Edit Report -> Select the date range you need -> select the specific master server -> Run Report

Does this work for you?

 

luisvidal
Level 5

Thanks, Watsons, but it doesn't seem to achieve what I am looking for.

Dollypee
Moderator
Moderator
   VIP    Certified

Are you running on opscenter analytic? if yes, try this query. filter out uwanted report.

========================================================================

SELECT
domain_JobArchive.policyName as "Policy Name",
domain_JobArchive.clientName as "Client Name",
domain_Client.hardwareDescription as "Platform",
domain_Client.versionLabel as "Version",
domain_JobArchive.scheduleName as "Schedule Name",
adjust_timestamp(domain_ScheduledJob.scheduledTime,10800000) as "Job Scheduled Time",
UTCBigIntToNomTime(domain_JobArchive.startTime) as "Job Start Time",
UTCBigIntToNomTime(domain_JobArchive.endTime) as "Job End Time",
SecToTime(DATEDIFF(minute,UTCBigIntToNomTime(domain_JobArchive.startTime),UTCBigIntToNomTime(domain_JobArchive.endTime))) as "Job Duration(Minutes)",
(CASE
 WHEN domain_JobArchive.state = 3 AND domain_JobArchive.statusCode = 0 THEN 'Successful'
 WHEN domain_JobArchive.state = 3 AND domain_JobArchive.statusCode = 1 THEN 'Partial'
 WHEN domain_JobArchive.state = 3 AND domain_JobArchive.statusCode > 1 THEN 'Failed'
 ELSE 'Failed'
END)  as "Job Status",
nb_JobFilesArchive.fileinfo as "Files",
CAST(domain_JobArchive.bytesWritten/1024/1024/1024 as NUMERIC(20,2)) as "Job Size(MB)",
domain_JobArchive.statusCode as "Status Code"

FROM domain_JobArchive,  lookup_JobState, domain_ScheduledJob, nb_JobFilesArchive, domain_MasterServer, domain_Client

WHERE domain_ScheduledJob.jobid  = domain_JobArchive.id
AND domain_JobArchive.masterserverId = nb_JobFilesArchive.masterserverId
AND domain_JobArchive.clientName = nb_JobFilesArchive.clientName
AND domain_JobArchive.id = nb_JobFilesArchive.jobID
AND domain_MasterServer.id = domain_JobArchive.masterServerId
AND domain_JobArchive.clientName = domain_Client.name
AND domain_JobArchive.masterserverId = domain_Client.masterserverId

AND domain_JobArchive.state =lookup_JobState.id AND DATEDIFF(hour,UTCBigIntToNomTime(domain_JobArchive.endTime), GETDATE()) <=24
AND domain_JobArchive.policyName != ''

===================================================================================

You can also take a look at this link from previous post :

https://www-secure.symantec.com/connect/forums/command-know-how-many-netbackup-clients-installed