Variables in Notifications

[sara_b]

We're using App Portal 2016 11.0.4 with SCCM/Casper integration.

When a user requests a Windows software, they get the out of the box "Software -Data" notification. Where does the information come from on the variables in the notifications? Specifically, I'm looking to find out where the ##InstallDate## is pulled from. The documentation simply says "Scheduled install date in client time.", but where is it getting that information? 

[CharlesW · Accepted solution]

The ##InstallDate## variable is set based on the InsertDate column in WD_packageRequests. The string "(client time)" is appended to the InsertDate value .. Many of the variables which are set for a given request are stored in the WD_PackageRequests table. While there is no published mapping between variables and column names, the column names may help to point you in the right direction.