Network Atlas Objects in Modern Dashboard with SWQL

Guac55

Hello,

I'm in the process of creating a modern dashboard, and I'm wondering if it's feasible to retrieve all the "Network Objects" from Network Atlas and present them in a table format within a custom SWQL on the Modern Dashboard?

Basically, I'm trying to have a table that lists all the Sites with links to their corresponding Network Atlas maps for quick access by clicking on the site names. Currently, in classic dashboard it's called "List of Objects on Network Map".

Is this achievable?

Devang_Vaghasiya

Hello @Guac55 

Yes, it is achievable!
I did not find any solution regarding it on THWACK so I have created custom SWQL.

SELECT  M.Timestamp AS Map_Created,
        SUBSTRING(M.FileName,1,(LENGTH(M.FileName) - 9)) AS Map_Name,  
        M.Owner AS Map_Owner,
        '/Orion/NetPerfMon/MapView.aspx?Map='+ SUBSTRING(M.FileName,1,(LENGTH(M.FileName) - 9)) AS Map_URL

FROM Orion.MapStudioFiles AS M
WHERE M.FileName LIKE '%OrionMap%' AND M.IsDeleted = FALSE
ORDER BY M.FileName

In the Query "M.FileName" returns file name with ".OrionMap" at the end. So, I have used SUBSTRING to trim it (Since, SWQL does not have TRIM() function)
Then I have added it with generalized Map link to get the full URL of the Map.

Hope, it will be helpful for you!