How to count all entries of a MS SQL DigaSystem Database
If you like to know "how many entries i have in a DigaSystem Database, you can use this SQL script.
For example i need this to calculate how may entries are created day by day to calculate job processors
SELECT t.name, t.create_date, t.modify_date ,s.row_count from sys.tables t JOIN sys.dm_db_partition_stats s ON t.object_id = s.object_id AND t.type_desc = 'USER_TABLE' AND s.index_id IN (0,1) AND name not like '%[_]T' AND name not like '%[_]M' AND name not like '%[_]E' AND name not like '%[_]X' AND name not like '%[_]F' AND name not like '%[_]C' AND name not like '%[_]S' AND name not like '%[_]L' AND name not like '%[_]V' AND name != 'HISTORY' AND name != 'LOCKED' AND name != 'DEFINITION' AND name != 'COLLECTION' AND name != 'DBVERSION' AND name != 'KEYWORD' AND name != 'DIGAS' AND name != 'DISPATCH_TASKS' AND name != 'FIELDDEF' AND name != 'REDUNDANCE' AND name != 'RESSORT' AND name != 'STATISTIC' AND name != 'sysdiagrams' AND name != 'DEF_DEF' order by t.modify_date DESC --order by t.name |
![]() |