A state land office in the United States needed both file system data and file system permissions included in the same report. This report was needed to demonstrate compliance to state requirements for access restricted to only authorized users.
Because they are easily generated as built-in reports in Galileo, File System Data and Permissions reports are oftentimes generated as separate reports. But this wouldn’t do for the land office’s compliance requirements.
A Condrey Corporation Support engineer was able to work with the land office IT department in developing a set of SQL commands for a Custom Query report that would provide this information and more. When the query was completed, the land office IT people simply pasted in the report parameters and generated their own report.
Since that time, the IT personnel at the state land office have written many other custom queries of their own and continue to utilize Galileo on an almost daily basis.