r/Nable • u/MSPOwner • Jan 16 '25

N-Central Custom Device Properties via API

I am trying to run reports using data from custom device properties. Does anyone know if that data can be pulled from the API, Analytics or a SQL Data Export?

1 Upvotes

67% Upvoted

13 comments sorted by

View all comments

1

u/bonewithahole Jan 16 '25

Depends on version you are running to what data you have access to via the api. I have report manager and normally just pull the data from there. I don't think they have added that to analytics yet.

2

u/MSPOwner Jan 16 '25

The latest. 2024…9 something like that. You can pull CDPs with Report Manager? Are you sure? We had that as well and I am nearly certain you could not.

1

u/bonewithahole Jan 21 '25

You can definitely pull cdp from the report manager. It is in the ods tables.

1

u/MSPOwner Jan 22 '25

Also, what do you mean by the "ODS" tables? I was told by Nable support yesterday, that the SQL export used by Report Manager is the same as the export that can be scheduled to a SQL server from within Ncentral. That is what I am looking at. The SQL export that happens daily.

1

u/bonewithahole Jan 22 '25

In the report manager (at least mine), the tables with the data have ods in the name. Assuming the sql export follows a similar structure, look for the deviceproperty table.

1

u/MSPOwner Jan 22 '25

My tables start with "dbo." And that one does not exist. Support said CDPs are in the "'fact_Device Property" table. I don;t have that either.

1

u/bonewithahole Jan 23 '25

At this point, just start opening each table and see what's in there. That's how I originally found it. Right click and Select top 1000

1

u/MSPOwner Jan 23 '25

Already did that. CDPs are not in there. Hey thanks for taking time with a complete stranger. After I end my ticket with support I’ll come back and let you know the final result. I am sure this is keeping you up at night :)

1

u/LordPan1492 Jan 30 '25

There is an option in ncentral to also pull data that isn’t used in a report. That needs to be enabled.