Stats - Report Counts etc.

[BHUMENY]

In CS, is there an easy way to get a count of reports by application group etc.
I had a number of queries set up for SFA, but they are no longer available in CS.

Thanks in advance.

[Joe Wolken]

Unlike SFA where all indexing records are stored in a single file, in CS the index records for each Application Group are stored in their own physical file in the library matching the name of your CS Instance. Each one starts with a unique, system generated, 3 characters. Th 3 character reference for each App Group can be found either in the ARSAG file or within OnD Admin Client App Group properties.
 
I believe you will need to create a query to count the number of records in each of these files. One query per application group.

[BHUMENY]

Thanks Joe.
I was able to use the info you supplied plus the following selections to get a report count.

                                 Select Records                               
                                                                             
 Type comparisons, press Enter.  Specify OR to start each new group.         
   Tests:  EQ, NE, LE, GE, LT, GT, RANGE, LIST, LIKE, IS, ISNOT...           
                                                                             
 AND/OR  Field                 Test   Value (Field, Number, 'Characters', or ...)
              DOC_OFF           EQ     0                                           
  AND      COMP_OFF         EQ     0                                           
  AND      DOC_NAME        LIKE   '%A'       


I had to run this against each AG table.

I was hoping to be able to get all of this from the ARSLOAD table, but it seems to be missing info.
This may be because we migrated from SFA to CS.                               

[Darrell Bryant]

If you are using ASM as your storage manager, you could use this SQL statement against the QARLCOIT file, which contain a row for each object stored in the instance.  In this SQL statement, the where clause selects the index objects (object name ending in 1), of which there should be one per load.

SELECT OBJECT_GROUP, COUNT(*) FROM QUSROND/QARLCOIT WHERE
TRIM(OBJECT_NAME) LIKE '%1' GROUP BY OBJECT_GROUP ORDER BY
OBJECT_GROUP

 If you are storing very large reports, you might have more than one data object name per load that ends in A.