Author notes:
I wrote this macro to be able to retrieve certain information about recurring instances, specifically event dependency and destination email addresses (if applicable to the schedule). This program is an Excel macro that will extract a list of all recurring instances in the repository and provide some stats about each : Name, update date, create date, parent report folder path, name of event dependency, destination email addresses and output type. This is yet another macro in my series of excel macros I’ve developed for extracting list-type information on reports or instances in my repository.
Credits:
Julien Bras - I used Julien’s code from the “BOXI UserList & Group Extraction” as a base for this macro.
General Code Description: This selects the SI_ID’s of all the recurring instances in the repository (I had 4000+) and loops through them all getting certain information about the parent report template (name, folder path, etc) then it loops through and extracts any information about event dependencies and destination email addresses.
NOTE: This code assumes you have no more than 50,000 instances. That’s the limit I set. You are free to adjust that by editing the code. This is also designed to work only with XI3.1, but you could adapt it to XIR2 by changing the library references. You must also be running Microsoft Office 2007 as this is an “.xlsm” file. If you are still running MS2003, this is a good excuse to get an upgrade from your company.
FYI, attachments are not visible in the Uploads forum for non-administrators. They are only visible once they are approved by a site administrator and moved to the Downloads forum.
As oScheduleInfo.Properties(“SI_DESTINATIONS”).Properties(“1”).Properties(“SI_DEST_SCHEDULEOPTIONS”).Properties(“SI_MAIL_ADDRESSES”).Properties(“1”).Value is being used to get the value, could you please guide me how to set this value to my desired dest email?
I am running this excellent utility at BI4 but I was wondering if anyone had the code to allow it to extract multiple email addresses & the cc addies too?
Instead of showing the destination being an email id, is it possible to tweak the code to instead show the destination folder path (if/when a report is being exported to a network folder, instead of being emailed)?
ie. export destination folder path & file name = “\Server\Folder\Subfolder\xxx.xls”
Okay, I am probably missing something completely obvious, but I am trying to pull back the SI_NEXTRUNTIME field instead of SI_CREATION_TIME and and can’t seem to get it to work. I simply changed the 5th row to the new field, but that field doesn’t return any data (note that when I randomly try using other fields in the 5th row it seems to work fine).
I can bring back the same information using Query Builder without issue, so I don’t know what I am doing wrong…
I have tried running this but get an error and it returns nothing, if I put in random info in the login screen it gives when you click ‘Connect CMS’ I get the same error, so its like it not even connecting.
I’m I missing something here, I take it by CMS its the same details I would enter under ‘System’ when I login to Designer, and username and pw are login you would use to login to CMC say as an Admin, and not the repo db login / pw ?
I was able to get it working by changing the code in the Visual basic
from
If oScheduleInfo.Properties(“SI_DESTINATIONS”).Properties(“1”).Properties(“SI_PROGID”) = “CrystalEnterprise.Smtp” Then
Rng(RowNum, 11) = oScheduleInfo.Properties(“SI_DESTINATIONS”).Properties(“1”).Properties(“SI_DEST_SCHEDULEOPTIONS”).Properties(“SI_MAIL_ADDRESSES”).Properties(“1”).Value
to
If oScheduleInfo.Properties(“SI_DESTINATIONS”).Properties(“1”).Properties(“SI_PROGID”) = “CrystalEnterprise.Ftp” Then
Rng(RowNum, 11) = oScheduleInfo.Properties(“SI_DESTINATIONS”).Properties(“1”).Properties(“SI_DEST_SCHEDULEOPTIONS”).Properties(“SI_SERVER_NAME”).Value
I am seeing the same behavior as well. Does anyone know if there is another way to gather this info quickly? Did attempting changing the libraries? Confused on the comment about changing the client tools?
The error I get is - CrystalEnterprise12.SessionMgr1. - -214721105: Enterprise authentication could not log you on. Please make sure your login information is correct.
We are using Windows AD authentication.
(BOB member since 2006-01-04)
(BOB member since 2006-03-06)
(BOB member since 2007-01-22)
(BOB member since 2003-11-27)
