Is there anyway to query Orion database rows in chunks using orionsdk?

Hi Last_Ninja the simple way is to something like

SELECT TOP 1000

The first time will return the first 1000 nodes.

Thanks.. Thats what I was looking for.

I am not sure why this site is keep removing my post with sql query. Basically I would like to only display unique NodeIDs as there are multiple results for same node id. I tried DISTINCT but it is not doing anything.

Is there any way to display only distinct node ids that has the newest config download time?

I don't have data to test this with, but I think a query like this should get you what you need.  If you group by the NodeID to find the max (latest) value in a subquery, you can then join that back to the table to grab values associated with the records you select, like the Config column:

SELECT
    ca.NodeID,
    ca.DownloadTime,
    ca.Config
FROM NCM.ConfigArchive ca
INNER JOIN
(
    SELECT NodeID, MAX(DownloadTime) AS LatestDownloadTime
    FROM NCM.ConfigArchive
    GROUP BY NodeID
) cam
ON cam.NodeID = ca.NodeID AND cam.LatestDownloadTime = ca.DownloadTime
ORDER BY ca.NodeID

I was scrolling down and thought "oh I have a query for that!" and then dan_jagnow got it already. 

Thank You! It worked and now I can run the query without doing chunks. The results went from over 10k to 1k 

Last question

Is there any way to query two tables? The NCM.ConfigArchive has node_id but that table does not contain sysName. I am going over each NodeId and getting sysName from NCM.Nodes. So, if there are 1k node ids, I am querying NCM.Nodes 1k time to get sysName for each ID.

Is there any way to call NCM.Nodes and get sysName and add it to the same sql query? So in one query we can get all unique nodes, configs from NCM.ConfigArchive as well as sysName from NCM.Nodes. All in one query?

Thanks!

Last_Ninja , you should be able to add ca.NodeProperties.Nodes.Caption as one of the fields, which should pull back your node names.

Can you please explain how. I tried couple things and so far it is not working for me.