Meta-Update has a sample that runs through arschema and builds a CSV of pertinent details plus a record count. Meta-Query allows you ARS and SQL queries without a database client.
A trial license is free and includes this and other samples. You would have your counts after a few minutes of our Live Install WebEx session. Arschema does not give a count of rows. It does give the next available '1' field value but that cannot be used as it will not take deletions and uncreated records into account. You can build a View form on arschema and populate an extra DO field on a Get filter with the count. Cheers Ben Chernys Senior Software Architect Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys_AT_softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor and out Freebies Section for an ITSM 7.6.04 Forms and Fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of remedyarl...@gmail.com Sent: April-26-12 11:58 To: arslist@ARSLIST.ORG Subject: Count of records Quick question.. Do we have a form in remedy 7.6.X where we can check the count of rows in each table. I know we have a form to check schema ID's but will this also give count of rows. My Getlist query on server is restricted to 2K records only so I have to run 1=1 query on each target form in web mode to get the count. Unfortunately user too do not give the count. Also I don't have read access to DB and client is not ready to share ARAdmin pwd (for security). And as usual no customization allowed. Any help would be appreciated. Sent on my BlackBerry® from Vodafone ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"