Micro Focus Email

Send E-mail

Self-Solve Knowledge Search

How to check File system tables for specific node

How to check File system tables for specific node

How to check File system tables for specific node

How to check File system tables for specific node

This document has not been formally reviewed for accuracy and is provided as is.

B-SL:100 HPSL:100 LIB4:false TYPE:errormsg HPTYPE:technical_documents ATT:0

Summary

How to check File system tables for specific node

Problem

We often need to check Filesystem report and why is empty with sql query in Vertica database

Fix

We can use below queries and modify the node and date accrdinlgly.

 

For Filesystem

select * from SR_SM_FILESYSTEM
where ta_period > '2016-04-01' and ta_period < '2016-04-27'
and dsi_key_id_ in (select dsi_key_id from K_SM_FILESYSTEM where DNS_Name like 'NODE_NAME')
and ShiftRef=1 order by ta_period

select * from SH_SM_FILESYSTEM
where ta_period > '2016-04-01' and ta_period < '2016-04-27'
and dsi_key_id_ in (select dsi_key_id from K_SM_FILESYSTEM where DNS_Name like 'NODE_NAME')
and ShiftRef=1 order by ta_period

select * from SD_SM_FILESYSTEM
where ta_period > '2016-04-01' and ta_period < '2016-04-27'
and dsi_key_id_ in (select dsi_key_id from K_SM_FILESYSTEM where DNS_Name like 'NODE_NAME')
and ShiftRef=1 order by ta_period

Additional Information

Was this document helpful? Feedback