Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Global Suppressed Alerts Dashboard - Need help in importing Modern Dashboard

WinterSoldier

Hi guys,

Can anyone help me importing this xml in modern dashboard?

Global Suppressed Alerts Dashboard.txt

I am getting an error while importing this.

Find more posts tagged with

moderndashborads

swql query

SolarWinds Self-Hosted Platform

Accepted answers

All comments

bourlis

Hi WinterSoldier,

Here's the SolarWinds KB article on how to upload/download dashboards into SolarWinds.

https://documentation.solarwinds.com/en/success_center/orionplatform/content/core-fusion-dashboard-import-export.htm

The assumption to this KB article is that you have SWQL Studio installed. If you do, then all you need to do is the 3 import steps:

Open SWQL Studio and search for the Orion.Dashboard.Instances entity.
Expand the Orion.Dashboards.Instances entity and click the Import verb.
Paste the exported JSON string (the characters between the <Return>...</Return> tags of the dashboard definition) into the definition text box in Orion.Dashboards.Instances.Export pane and click Invoke to import the dashboard.

If done correctly you'll get a message that looks something like this:

- <Fault xmlns="http://www.w3.org/2003/05/soap-envelope">- <Code> <Value>Sender</Value> </Code>- <Reason> <Text xml:lang="">Orion.Dashboards.Instances.Import failed, check fault information. Value cannot be null. Parameter name: key</Text> </Reason>- <Detail>- <InformationServiceFaultContract xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.solarwinds.com/2007/08/informationservice"> <Message>Value cannot be null. Parameter name: key</Message> </InformationServiceFaultContract> </Detail> </Fault>- <Fault xmlns="http://www.w3.org/2003/05/soap-envelope">

- <Code>

 <Value>Sender</Value>

 </Code>

- <Reason>

 <Text xml:lang="">Orion.Dashboards.Instances.Import failed, check fault information. Value cannot be null. Parameter name: key</Text>

 </Reason>

- <Detail>

- <InformationServiceFaultContract xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.solarwinds.com/2007/08/informationservice">

 <Message>Value cannot be null. Parameter name: key</Message>

 </InformationServiceFaultContract>

 </Detail>

 </Fault>

Plz let me know if you run into any issues. If you do, I'll post the SWQL script, which will work, but you won't have the icons that I selected for the dashboard view. But I can help you with those too if you want.

WinterSoldier

I am getting this error.

<Fault xmlns="http://www.w3.org/2003/05/soap-envelope">
<Code>

<Value>Sender</Value>
</Code>

<Reason>

<Text xml:lang="">Orion.Dashboards.Instances.Import failed, check fault information. Unexpected character encountered while parsing value: x. Path '', line 0, position 0.</Text>
</Reason>

<Detail>
<InformationServiceFaultContract xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.solarwinds.com/2007/08/informationservice">

<Message>Unexpected character encountered while parsing value: x. Path '', line 0, position 0.</Message>
</InformationServiceFaultContract>
</Detail>
</Fault>

bourlis

I often get errors like this, but the dashboard gets uploaded anyway. I would go to manage dashboards and search for your new dashboard. If it's not there then here's the SWQL query:

SELECT 

n.Caption AS [System Name]

, CASE 

    when s.ScheduleTask.ScheduleType is NULL then ''

    ELSE s.ScheduleTask.ScheduleType

    END as [Schedule Type]

, CASE

    when s.ScheduleTask.AccountID is NULL then ''

    ELSE s.ScheduleTask.AccountID 

    END as [Suppressed By]

, CASE 

    when s.ScheduleTask.name is NULL then ''

    ELSE s.ScheduleTask.name

    end as [Suppression Description]

, CASE

    when s.ScheduleTask.Reason is NULL then ''

    ELSE s.ScheduleTask.Reason

    END as [Suppression Reason]

, CASE

    WHEN s.ScheduleTask.NextRun is NULL then ''

    ELSE TOSTRING(TOLOCAL(s.ScheduleTask.NextRun))

    End as [Scheduled Date]

, CASE 

    WHEN n.UnManaged != 'False' then 'Unmanaged'

    ELSE ''

    END as [Unmanaged]

, CASE

    WHEN n.UnManaged <> 'False' then TOSTRING(TOLOCAL(n.UnManageFrom))

    ELSE ''

    END as [Start Unmanage]


, CASE

    WHEN n.UnManaged <> 'False' then TOSTRING(TOLOCAL(n.UnManageUntil))

    ELSE ''

    END as [End Unmanage]

, CASE

    when z.ID like '%' then 'Muted'

    ELSE ''

    END as [Muted]

, CASE

    when z.SuppressFrom is NULL then ''

    ELSE TOSTRING(TOLOCAL(z.SuppressFrom))

    End AS [Start Mute]

, CASE

    WHEN z.SuppressUntil is NULL then ''

    ELSE TOSTRING(TOLOCAL(z.SuppressUntil))

    End AS [End Mute]

,n.DetailsURL AS [Details URL]

,n.Status

,n.VendorIcon


FROM Orion.Nodes AS n


left join Orion.ScheduleEntityAssignment s on n.uri = s.EntityUri

left JOIN orion.AlertSuppression z on N.Uri = Z.EntityUri



where s.ScheduleTask.Enabled = 'TRUE'

    and (s.ScheduleTask.NextRun is NOT NULL) 

    or (n.UnManaged != 'False') 

    or (z.ID like '%')

bourlis

I often get error like this, but the dashboard gets uploaded anyway. Have you searched for the new dashboard yet? Just in case here's the SWQL query.

SELECT 

n.Caption AS [System Name]

, CASE 

    when s.ScheduleTask.ScheduleType is NULL then ''

    ELSE s.ScheduleTask.ScheduleType

    END as [Schedule Type]

, CASE

    when s.ScheduleTask.AccountID is NULL then ''

    ELSE s.ScheduleTask.AccountID 

    END as [Suppressed By]

, CASE 

    when s.ScheduleTask.name is NULL then ''

    ELSE s.ScheduleTask.name

    end as [Suppression Description]

, CASE

    when s.ScheduleTask.Reason is NULL then ''

    ELSE s.ScheduleTask.Reason

    END as [Suppression Reason]

, CASE

    WHEN s.ScheduleTask.NextRun is NULL then ''

    ELSE TOSTRING(TOLOCAL(s.ScheduleTask.NextRun))

    End as [Scheduled Date]

, CASE 

    WHEN n.UnManaged != 'False' then 'Unmanaged'

    ELSE ''

    END as [Unmanaged]

, CASE

    WHEN n.UnManaged <> 'False' then TOSTRING(TOLOCAL(n.UnManageFrom))

    ELSE ''

    END as [Start Unmanage]


, CASE

    WHEN n.UnManaged <> 'False' then TOSTRING(TOLOCAL(n.UnManageUntil))

    ELSE ''

    END as [End Unmanage]

, CASE

    when z.ID like '%' then 'Muted'

    ELSE ''

    END as [Muted]

, CASE

    when z.SuppressFrom is NULL then ''

    ELSE TOSTRING(TOLOCAL(z.SuppressFrom))

    End AS [Start Mute]

, CASE

    WHEN z.SuppressUntil is NULL then ''

    ELSE TOSTRING(TOLOCAL(z.SuppressUntil))

    End AS [End Mute]

,n.DetailsURL AS [Details URL]

,n.Status

,n.VendorIcon


FROM Orion.Nodes AS n


left join Orion.ScheduleEntityAssignment s on n.uri = s.EntityUri

left JOIN orion.AlertSuppression z on N.Uri = Z.EntityUri



where s.ScheduleTask.Enabled = 'TRUE'

    and (s.ScheduleTask.NextRun is NOT NULL) 

    or (n.UnManaged != 'False') 

    or (z.ID like '%')

WinterSoldier

Thank you for providing this SWQL. Does this query differs from version to version? This swql works on v2025.4 but it throws an error on v2025.2.1.

screenshot.jpg