Adaxes

SSRS Report of Adaxes Data

0 votes

I've been tasked with writing a SQL Server Reporting Services report of our AD data and at least one Adaxes custom attribute. SSRS has the following built-in data source options:

Microsoft SQL Server
Microsoft SQL Azure
Microsoft SQL Server Parallel Data Warehouse
Microsoft SQL Server Analysis Services
OLE DB
Oracle
ODBC
XML
Report Server Model
SAP NetWeaver BI
Hyperion Essbase
TERADATA

I believe we need to query Adaxes to include the custom attribute along with the AD objects, and I believe none of these data sources connect directly to Adaxes. Do you know of a good approach to my task?

Edit 6-28: It looks like I need to use the Softerra ADSI Provider API, a .NET3.5 WCF service, and a report that reads an XML data source. The WCF service will query Adaxas/AD via the ADSI provider, then expose a constructed dataset to the SSRS report.

by (40 points)

Please log in or register to answer this question.

Related questions

0 votes
1 answer
Has any progress been made on providing a report of who has access in Adaxes?

Our audits require us to provide a report of who has access in applications. Most applications provide a way to produce this access report. Can Adaxes add this feature?

asked Nov 7 by lavonnabalo (40 points)
0 votes
1 answer
Custom Report Based on Logging Data Filter Criteria

Hello, I'd like to create a custom Adaxes report based on the following Logging Filters - I'm currently having to filter the logs manually each time I want to gather this ... would be easier to jump on a call to discuss this further? Thank you in advance!

asked Nov 16, 2020 by sirslimjim (480 points)
0 votes
1 answer
How do I create an export of delta data only?

This is what I need to accomplish. Day one, I perform an export of the following four attributes for all Users in AD - DN, employeeID, telephoneNumber, location. Day 2, ... in which one of them has changed. It possible to achieve this using a scheduled task?

asked Mar 23, 2015 by sbanks (270 points)
0 votes
1 answer
Leveraging last interactive sign in data from Azure AD inside the Adaxes Management Console

Hello there, We have recently moved (almost) every computer from on-prem to cloud only and have setup some scheduled tasks to disable users based off of Last Logon and Last Logon ... in a different way? And if not, are there any plans to leverage that data?

asked May 21 by jacobchugg (20 points)
0 votes
1 answer
How to store data in Adaxes configuration?

The Adaxes Script Repository used to have two related scripts "Get custom value stored in Adaxes configuration" and "Store data in Adaxes configuration". These scripts ... /https://www.adaxes.com/script-repository/store-data-in-adaxes-configuration-s430.htm

asked Sep 1, 2023 by Carl Bruinsma (120 points)
3,548 questions
3,239 answers
8,232 comments
547,814 users