This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

License Saturation in SQL?

cscoengineer over 1 year ago

Hi All,

There is a Orion.LicenseSaturation table in SWQL. Is there anything similar on the SQL tables?

Thank you,

Amit

Top Replies

KMSigma over 1 year ago in reply to cscoengineer +1 verified

From a technical sense, I don't know if the information is in SQL, but my guess is that it is somewhere - unless it's buried in the file system or something even more obscure.. However finding…

Parents

0 m-milligan over 1 year ago

It appears that there is not a corresponding SQL table. I queried Orion.LicenseSaturation in SWQL Studio using the WITH QUERYPLAN hint. When a query pulls data from SQL tables, the query plan will show an OptType of "ProviderPassThroughScanOp" query - that's the text of the SQL query that's sent to SQL Server.

This is my query against Orion.LicenseSaturation:

Select ElementType, ElementCount, MaxCount from Orion.LicenseSaturation with QUERYPLAN

And this is the query plan:

- <queryPlan type="physical" xmlns="schemas.solarwinds.com/.../informationservice">

- <op type="ProjectOp">

- <selectors>

<selector name="T1.C1" type="String" expression="PropertyRef/T1.C1" />

<selector name="T1.C2" type="Int32" expression="PropertyRef/T1.C2" />

<selector name="T1.C3" type="Int32" expression="PropertyRef/T1.C3" />

</selectors>

- <metaData>

<field name="T1.C1" type="String" ordinal="0" xmlPath="LicenseSaturation[EntityType=Orion.LicenseSaturation]/@ElementType" />

<field name="T1.C2" type="Int32" ordinal="1" xmlPath="LicenseSaturation[EntityType=Orion.LicenseSaturation]/@ElementCount" />

<field name="T1.C3" type="Int32" ordinal="2" xmlPath="LicenseSaturation[EntityType=Orion.LicenseSaturation]/@MaxCount" />

</metaData>

- <children>

- <op type="ProviderScanOp" name="T1" entity="Orion.LicenseSaturation">

- <metaData>

<field name="T1.C1" type="String" ordinal="0" />

<field name="T1.C2" type="Int32" ordinal="1" />

<field name="T1.C3" type="Int32" ordinal="2" />

</metaData>

<children />

</op>

</children>

</op>

</queryPlan>

As you see, there's no reference to a ProviderPassThroughScanOp.

By contrast, here's a query against Orion.Nodes:

SELECT TOP 10 Caption, IP from Orion.Nodes WITH QUERYPLAN

And here is its query plan:

- <queryPlan type="physical" xmlns="schemas.solarwinds.com/.../informationservice">

- <op type="ProjectOp">

- <selectors>

<selector name="T1.C1" type="String" expression="PropertyRef/T1.C1" />

<selector name="T1.C2" type="String" expression="PropertyRef/T1.C2" />

</selectors>

- <metaData>

<field name="T1.C1" type="String" ordinal="0" xmlPath="nodes[EntityType=Orion.Nodes]/@caption" />

<field name="T1.C2" type="String" ordinal="1" xmlPath="nodes[EntityType=Orion.Nodes]/@ip" />

</metaData>

- <children>

- <op type="ProviderPassThroughScanOp">

<passThrough>SELECT TOP 10 [T1].[Caption] AS C1, [T1].[IP_Address] AS C2 FROM [dbo].[NodesData] AS T1 WITH QUERYPLAN RETURN XML Raw</passThrough>

- <metaData>

<field name="T1.C1" type="String" ordinal="0" />

<field name="T1.C2" type="String" ordinal="1" />

</metaData>

<children />

</op>

</children>

</op>

</queryPlan>
Cancel
Up 0 Down

Cancel

Reply

0 m-milligan over 1 year ago

It appears that there is not a corresponding SQL table. I queried Orion.LicenseSaturation in SWQL Studio using the WITH QUERYPLAN hint. When a query pulls data from SQL tables, the query plan will show an OptType of "ProviderPassThroughScanOp" query - that's the text of the SQL query that's sent to SQL Server.

This is my query against Orion.LicenseSaturation:

Select ElementType, ElementCount, MaxCount from Orion.LicenseSaturation with QUERYPLAN

And this is the query plan:

- <queryPlan type="physical" xmlns="schemas.solarwinds.com/.../informationservice">

- <op type="ProjectOp">

- <selectors>

<selector name="T1.C1" type="String" expression="PropertyRef/T1.C1" />

<selector name="T1.C2" type="Int32" expression="PropertyRef/T1.C2" />

<selector name="T1.C3" type="Int32" expression="PropertyRef/T1.C3" />

</selectors>

- <metaData>

<field name="T1.C1" type="String" ordinal="0" xmlPath="LicenseSaturation[EntityType=Orion.LicenseSaturation]/@ElementType" />

<field name="T1.C2" type="Int32" ordinal="1" xmlPath="LicenseSaturation[EntityType=Orion.LicenseSaturation]/@ElementCount" />

<field name="T1.C3" type="Int32" ordinal="2" xmlPath="LicenseSaturation[EntityType=Orion.LicenseSaturation]/@MaxCount" />

</metaData>

- <children>

- <op type="ProviderScanOp" name="T1" entity="Orion.LicenseSaturation">

- <metaData>

<field name="T1.C1" type="String" ordinal="0" />

<field name="T1.C2" type="Int32" ordinal="1" />

<field name="T1.C3" type="Int32" ordinal="2" />

</metaData>

<children />

</op>

</children>

</op>

</queryPlan>

As you see, there's no reference to a ProviderPassThroughScanOp.

By contrast, here's a query against Orion.Nodes:

SELECT TOP 10 Caption, IP from Orion.Nodes WITH QUERYPLAN

And here is its query plan:

- <queryPlan type="physical" xmlns="schemas.solarwinds.com/.../informationservice">

- <op type="ProjectOp">

- <selectors>

<selector name="T1.C1" type="String" expression="PropertyRef/T1.C1" />

<selector name="T1.C2" type="String" expression="PropertyRef/T1.C2" />

</selectors>

- <metaData>

<field name="T1.C1" type="String" ordinal="0" xmlPath="nodes[EntityType=Orion.Nodes]/@caption" />

<field name="T1.C2" type="String" ordinal="1" xmlPath="nodes[EntityType=Orion.Nodes]/@ip" />

</metaData>

- <children>

- <op type="ProviderPassThroughScanOp">

<passThrough>SELECT TOP 10 [T1].[Caption] AS C1, [T1].[IP_Address] AS C2 FROM [dbo].[NodesData] AS T1 WITH QUERYPLAN RETURN XML Raw</passThrough>

- <metaData>

<field name="T1.C1" type="String" ordinal="0" />

<field name="T1.C2" type="String" ordinal="1" />

</metaData>

<children />

</op>

</children>

</op>

</queryPlan>
Cancel
Up 0 Down

Cancel

Children

No Data