Hi All,
There is a Orion.LicenseSaturation table in SWQL. Is there anything similar on the SQL tables?
Thank you,
Amit
Hi All,
There is a Orion.LicenseSaturation table in SWQL. Is there anything similar on the SQL tables?
Thank you,
Amit
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>
</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>
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>
</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>
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.