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.
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
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.
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.
Create a new Trigger. Select Periodic and click OK
Select the frequency you would like the report to run. Select OK
Create an action
Select Action type Report
Then choose the report you've created in Step 1:
Click OK
Save and Close
The Automation Rule will look like this:
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.
Once the sync is complete, the changes should be applied.