DQL SDK document

Hi, 

You can find a most recent publication of SDK on SORT, or in zip file when you download Datainsight 6.0.

Concerning filegroups, I extract information from "filegroup" column in path table, and then I used SQL query to format the result. here a sample of what I do. The report produces a listing containing Volume and number of files for known and unknown filegroups

FROM path
GET basename, filegroups, extension, size
IF type="FILE"
FORMAT filegroups AS TABLE filegroups
SORTBY filegroups

/* SQL query *//

CREATE TABLE path_MB(path_rowid INTEGER, filegroups TEXT, no_files INTEGER, size_MB INTEGER);
INSERT INTO path_MB
SELECT a.path_rowid, b.filegroups, COUNT(a.basename), ROUND(sum(a.size)/1048576.0, 2) 
  FROM path a, filegroups b
  WHERE a.path_rowid=b.path_rowid
  AND a.extension!=''
  GROUP BY b.filegroups
UNION
SELECT a.path_rowid,'Unclassified File Group', COUNT (a.basename), ROUND(SUM(a.size)/1048576.0, 2) 
  FROM path a
  WHERE a.extension=''