How to configure a process to send a Consolidated Email to Line Manager with the detail of all it's direct reportees ?

Hi Experts,

I would like to configure the mail step where I want to send a reminder to the line manager for all it's direct reportees with details of the last login time stamp of each of the employee for a 90/180 inactivity process prior to disabling.

I have already configured the process where email will go to employee.

Kindly provide some suggestions as in how to achieve this?

Parents Reply Children
  • Yes Markus. It's for the Active Directory Logon Time Stamp.

  • I would create a simple list report then containing the AD User information and send this report to the manager.

    The report definition would look similar to this and uses two parameters.

    Days = Integer parameter. Number of days of last login (-90, -180).

    Manager = UID_Person of Manager

    <DatabaseExportDefinition BaseTable="ADSAccount" TimeZone="UTC">
    	<WhereClause>isnull(LastLogon, '1899-12-30 00:00:00.000') < DateAdd(dd, @Days, GetUTCDate()) AND UID_Person IN (Select UID_Person FROM Person Where UID_PersonHead = @Manager)
    	</WhereClause>
    	<Columns>
    		<Column TableName="ADSAccount" ColumnName="CanonicalName" ExportDisplay="False" />
    		<Column TableName="ADSAccount" ColumnName="SAMAccountName" ExportDisplay="False" />
    		<Column TableName="ADSAccount" ColumnName="cn" ExportDisplay="False" />
    		<Column TableName="ADSAccount" ColumnName="LastLogon" ExportDisplay="False" />
    	</Columns>
    </DatabaseExportDefinition>

    HtH

  • Thank You Markus for the suggestion.

    But can this be put into an SMTP Mail Process step?

    For e.g. - Let's say I have a manager M and there are 3 employees reporting to him E1, E2 & E3.

    I would like to send one consolidated email on the 90th Day of AD Inactivity like below

    Dear M,

    The below employee's reporting to you have not used their Active Directory account for more than 90Days

    Details of Employees

    E1.Name, E1.UserID, E1.ADLastLogon TimeStamp

    E2.Name, E2.UserID, E2.ADLastLogon TimeStamp

    E3.Name, E3.UserID, E3.ADLastLogon TimeStamp

    Regards,

    Signature

     

    Currently, as per the setup which I have made, 3 different emails are being delivered to the manager for each of its employee.

  • You need to run your process on a daily schedule and it needs to be based on your "Managers" so that the process is only generated once per Manager and not per employee.