How to check File system tables for specific node

  • KM03687020
  • 28-Jul-2020
  • 28-Jul-2020

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

Summary

How to check File system tables for specific node

Error

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