The ultimate customized experience
Category Coming Soon Reporting
Bookmark :
We often get asked about how best to share SPACEWatch search and analysis results amongst multiple users - and as you might expect, SPACEWatch presents a range of solutions depending on the users involved.
However one question that pops up regularly is how to create custom reports.
You've always been able to create custom analysis results using the File or Directory Finder, or Virtual Folders for more sophisticated needs - but these have their limitations. To address this we've been constructing a new custom reporting capability behind the scenes and will be launching this in SPACEWatch Enterprise, Domino and Exchange Editions from v5.7.65.
With this new capability you can take simple XML-based report templates and create even the most complex custom reporting scenarios. We'll provide examples and can even help you construct your own.
Automation gets everywhere
And if that wasn't enough, you'll be able to automate your custom reports via scripts, and even define the output format and have those reports sent straight to your inbox. You can pass arguments to your custom reports from your scripts, so for example you can re-use a departmental report with different areas of storage in your space database.
Now you can set up your monthly storage reporting for end users representatives, then have the results automatically email'd for you. Get rid of those excuses and get your storage cleaned up!
Getting started
Once you've got v5.7.65 or later installed, you'll find a new directory in the installation folder called "Custom Reports". This will contain some 'rpx' files which are the custom report file types. You can look at these with a plain text editor such as Notepad.
To run a custom report simply open it from within SPACEWatch using the new Analyze - Reports - Open Custom Report option. Just choose your rpx file and it will be loaded and the report will be immediately executed. You can then do all the usual copy, save/export etc. of report results that you can with the built-in SPACEWatch reports.
To include custom reports in your automation scripts you need to use the new /R options - search for 'custom reports' in the updated product help to see a full explanation of these.
Note that the SQL syntax used will depend on your database server. Take a look at the applications summary example and you'll see how you can make the report database server-independent.
If you want to include options from your script command lines in the SQL queries you use the 'GetOptions' function. You can see this in action in the duplicates example, where you can optionally limit the duplicates search to a particular sub-set of your space database.
Bookmark :
We often get asked about how best to share SPACEWatch search and analysis results amongst multiple users - and as you might expect, SPACEWatch presents a range of solutions depending on the users involved.
However one question that pops up regularly is how to create custom reports.
You've always been able to create custom analysis results using the File or Directory Finder, or Virtual Folders for more sophisticated needs - but these have their limitations. To address this we've been constructing a new custom reporting capability behind the scenes and will be launching this in SPACEWatch Enterprise, Domino and Exchange Editions from v5.7.65.
With this new capability you can take simple XML-based report templates and create even the most complex custom reporting scenarios. We'll provide examples and can even help you construct your own.
Automation gets everywhere
And if that wasn't enough, you'll be able to automate your custom reports via scripts, and even define the output format and have those reports sent straight to your inbox. You can pass arguments to your custom reports from your scripts, so for example you can re-use a departmental report with different areas of storage in your space database.
Now you can set up your monthly storage reporting for end users representatives, then have the results automatically email'd for you. Get rid of those excuses and get your storage cleaned up!
Getting started
Once you've got v5.7.65 or later installed, you'll find a new directory in the installation folder called "Custom Reports". This will contain some 'rpx' files which are the custom report file types. You can look at these with a plain text editor such as Notepad.
To run a custom report simply open it from within SPACEWatch using the new Analyze - Reports - Open Custom Report option. Just choose your rpx file and it will be loaded and the report will be immediately executed. You can then do all the usual copy, save/export etc. of report results that you can with the built-in SPACEWatch reports.
To include custom reports in your automation scripts you need to use the new /R options - search for 'custom reports' in the updated product help to see a full explanation of these.
Note that the SQL syntax used will depend on your database server. Take a look at the applications summary example and you'll see how you can make the report database server-independent.
If you want to include options from your script command lines in the SQL queries you use the 'GetOptions' function. You can see this in action in the duplicates example, where you can optionally limit the duplicates search to a particular sub-set of your space database.
