AccessNSite Integration Setup – Princeton Identity

Princeton Identity is glad to feature an integration with AccessNSite! The steps to setup the IDS synchronization are listed below.

Create a Report:

1. Navigate to the report Management -> Reports.

AccessNSite Step 1.png

2. Click on Add

- Create a new report. This example one is labelled “PersonalWithActiveBadges” You can name it something of your choice. This name will be used in the sync settings.
- Make sure that your max results are set large enough to handle all of the personnel.
- Copy the following SQL code into the SQL field

AccessNSite Step 2.png

SELECT vp.first_name as 'First Name', vp.middle_name as 'Middle Name', vp.last_name as 'Last Name',

vb.facility_code as 'Facility Code', vb.card_num as 'CardNumber',

vp.unid as 'Unique ID'

FROM vx_pnl vp

JOIN (vx_cred vc, vx_badge vb)

ON vp.unid = vc.assigned_to

AND vc.unid = vb.unid

and vc.validity_type = 'VX.ACTIVE'

3. Click Run the to confirm the results. You should see your report as specified.

AccessNSite Step 3.png

Setup a schedule for the report to run on

Navigate to Configuration -> Automation Rules

Add a name. I named mine “PersonalWithActiveBadges Report” as an example.

AccessNSite Schedule Step 1.png

Create a new Trigger. Select Periodic and click OK

AccessNSite Create Trigger and select Trigger Type.png

Select the frequency you would like the report to run. Select OK

AccessNSite Report Frequency.png

Create an action

Select Action type Report

AccessNSite Select Action Type.png

Then choose the report you've created in Step 1:

AccessNSite Selecting the Report Created in Step 1.png

Click OK

Save and Close

The Automation Rule will look like this:

AccessNSite Automation Rule.png

Select Save and close

Create a folder in a location of your choosing, for example:

“C:\IDSReport”

Create a hard link from the csv report to the new folder. Change C:\Users\Administrator\Downloads\AccessNsite-windows-V7_9_43_0\ to match your AccessNSite installation.

“mklink /h C:\IDSReport\YourReportNameHere.csv C:\Users\Administrator\Downloads\AccessNsite-windows-V7_9_43_0\YourReportNameHere.csv”

If it was successful, you will see the following.

Hardlink created for C:\IDSReport\YourReportNameHere.csv <<===>> C:\Users\Administrator\Downloads\AccessNsite-windows-V7_9_43_0\YourReportNameHere.csv

Next,

Go to Hardware - Tree. Under the server name, select Automation Driver, then select edit/right click, then invoke automation rule, select the report you created, then run the IDS sync.

AccessNSite IDS Sync Shot.png

Once the sync is complete, the changes should be applied.

Related articles