Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/22/26 01:07 PM
    Edited by brenda grossnickle 01/22/26 02:14 PM

    Wondering if anyone knows how to retrieve the Active Directory (AD) email recipients of Schedules? I am writing a MS SQL program to read the Cognos Content Store and create a list of all Cognos schedules. I can retrieve the schedule email recipient if the email was entered. But am unable to return the email if it was selected from LDAP/Active Directory. MotioPI free shows the AD name for schedules, but not the AD email. When I ran MotiotPI I did not enter the AD namespace binding credentials or point to cogstartup.xml. So I feel that retrieving the AD email or phone must be possible – but how? I see the CAMID below but how to use that if the AD name is not a Cognos user? 

    CMOBJPROPS26 delivoptions – if email is entered

     

    toAddress;deliveryOptionEnum;deliveryOptionAddressSMTPArray toAddress;deliveryOptionEnum;deliveryOptionAddressSMTPArray;155;

    <value xsi:type="SOAP-ENC:Array"

           SOAP-ENC:arrayType="bus:addressSMTP[1]">

                    <item xsi:type="bus:addressSMTP">Paige.Johnson@fisglobal.com

    </item>

    </value>

    CMOBJPROPS26 delivoptions – if email is selected from Active Directory

     

    to;deliveryOptionEnum;deliveryOptionSearchPathMultipleObjectArray;220;

    <value xsi:type="SOAP-ENC:Array"

           SOAP-ENC:arrayType="bus:searchPathMultipleObject[1]">

                    <item xsi:type="bus:searchPathMultipleObject">CAMID("HORIZON360BI:u:699d620f2d655449a26c11dc20fca9cd")

    </item>



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------



  • 2.  RE: How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/22/26 01:42 PM

    Hi Brenda,  The schedule will provide the user id for a non-smtp recipient and then what we do is get the email address and other attributes from Active Directory. What is it that you are trying to do overall? Best Paul.
    paul.hulford@attaininsight.com



    ------------------------------
    Paul Hulford
    ------------------------------



  • 3.  RE: How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/22/26 02:15 PM

    I edited my original post to include "I am writing a MS SQL program to read the Cognos Content Store and create a list of all Cognos schedules." Thought that i was done but now it is reported that email recipients that are select via Active Directory are not showing on the list of all cognos schedules report.



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 4.  RE: How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/22/26 06:02 PM

    Got it. Thanks Brenda. You might need to see if anyone else has a suggestion that works for SQL.  We use REST to query multiple Cognos instances at the same time in parallel. This gives gives us the Schedule and Recipient information including email address by Cognos instance (and then Cognos Reports to make the query results available). It works well and is fast but is a different approach to using SQL. I'm sure someone can advise where to get email address using SQL directly against the Content Store. Best Paul.



    ------------------------------
    Paul Hulford
    ------------------------------

    Original Message


  • 5.  RE: How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/23/26 09:25 AM

    Does the REST return email address of recipients that were entered from LDAP/Active Directory? Just curious. It is not apple to apples as obviously Cognos has the ability to traverse the active directory whereas SQL does not.



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------

    Original Message


  • 6.  RE: How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/23/26 09:39 AM

    Hi Brenda, Yes you are right, it is not apples to apples. Both REST and SDK can get email address for your normal Active Directory or LDAP Cognos configuration (noting that the standard "mail" attribute is not a mandatory field in either Active Directory or LDAP).  You need more than one API call to get email address for recipients that are Directory Service users rather than SMTP recipients. Best Paul.



    ------------------------------
    Paul Hulford
    ------------------------------

    Original Message


  • 7.  RE: How to retrieve the Active Directory (AD) email recipients of Schedules

    Posted 01/23/26 11:19 AM

    H Brenda -- 

    Since you are using MSSQL, you could use SSIS to run a PowerShell script to extract the data to a CSV file.  Add an "Execute Process Task" with the executable being "drive:\FileLocation\PowerShell.exe" with the parameters to get data out of AD (see URL link below).  Once you have it out as a CSV file, you import that into a MS database table and you can do the rest by joining that with your current SQL you have.

    https://learn.microsoft.com/en-us/answers/questions/239938/export-ad-users-to-csv-file

    Schedule that SSIS job to run daily, weekly, monthly, etc and you will be in good shape.

    Hope that helps.



    ------------------------------
    John Cusack
    Analytica iQ
    ------------------------------

    Original Message


Related Content