I use the following script to get the tables having identity values....
SELECT table_name
,column_name
,IDENT_CURRENT(table_name) as Identity_value
,data_type
FROM information_schema.columns
WHERE COLUMNPROPERTY(OBJECT_ID(table_name),column_name,'IsIdentity')=1
ORDER BY table_name
Why bother with system tables, when you can get the same with schema view and functions?