Reading query count by StatusID for a group of like configurations

The Reading Query Count by StatusID for a Group of Like Configurations reads by StatusID for a group of configurations with a similar naming structure.

select statusid, count (*) from Reading

where endtime > TIMESTAMP'2009-07-16 04:30:00' AND ENDTIME <= TIMESTAMP'2009-07-17 04:00:00'

and NodeID in (select spcnodeid as NodeID from flatconfigphysical where servicepointid like

{like configurations}%') by statusid

Related topics:

• FileInventory table

• Interpreting ARI file types and states

• Import Statistics query

• Reads Processed query

• Failed Reads query

• Reading query for a group of like configurations

• Reading table