cancel
Showing results for 
Search instead for 
Did you mean: 

Cleaning tape report

Tabriz
Level 5

Hi Dear Community,

 

How l can make report for cleaning tape on OpsCenter ?  For example if  the cleaning number remains 5 ? OpsCenter send me a report.

 

Thanks

 

 

5 REPLIES 5

davidmoline
Level 6
Employee

Hi @Tabriz 

I don't think there is a supplied report that would do this, but the information is contained in the doman_media and/or nb_media tables, so you should be able to write a custom SQL report to generate what you are after.

Cheers
David

 

Thanks for the response! @davidmoline 

Do l need to connect Database? 

Which Database l have to connect?

Br,

Tabriz

Hi @Tabriz 

On the assumption you have access to create SQL queries in OpsCenter this report will provide a basis to work with:

select
top 100 start at 1 nb_Media.id as "MediaID",nb_Media.cleaningCount as "Count"

from nb_Media

where nb_Media.cleaningCount < 5

If you don't have the analytics license for OpsCenter, then you could do the same (similar) by setting up a remote ODBC connection to the OpsCenter database and run your SQL remotely - see this article for guidance on setting this up:
https://www.veritas.com/support/en_US/article.100003321

Cheers
David

ear @davidmoline  Thank you for the response!

 

on this query l have to write which you wrote ? Or instead of the "MediaID" = "CLNU22" (the cleaning tape which l want to report mount) and "Count" = "35" (which the cleaning number is remains)

Br,

Tabriz

Hi @Tabriz 

No MediaID and Count become headers for the report that will be created. 

The report should list all cleaning media in your system with a cleaning count left of less than 5. 

If you change that comparison to >0, then you should see all cleaning media.

David