Useful SQL Queries
The following are some useful SQL Queries when working with connector list db files:
Query objects by shortid:
SELECT * FROM discobj WHERE shortid = ‘<shortid>’
Query attributes for object based on stableid:
SELECT * FROM discobjattr WHERE type = '<ACCT|GRP>’ and stableid = '<stableid>';
Query relationships for object based on stableid:
SELECT * FROM discobjrel WHERE type = '<ACCT|GRP>’ and stableid = '<stableid>';