Reading query for a group of like configurations

The Reading Query for a Group of Like Configurations displays all the reads for a group of configurations with similar names for a specific time frame.

select * from Reading

where endtime > TIMESTAMP'2009-05-31 04:30:00' AND ENDTIME <= TIMESTAMP'2009-06-02 05:00:00'

and NodeID in (select spcnodeid as NodeID from flatconfigphysical where servicepointid like '{like configurations}%')

order by NodeID, EndTime ASC

Related topics:

• FileInventory table

• Interpreting ARI file types and states

• Import Statistics query

• Reads Processed query

• Failed Reads query

• Reading table

• Reading query count by StatusID for a group of like configurations