Queries Folder

The Catalog folder \\Public\Meridium\Modules\Asset Strategy Management\Management\Queries contains the baseline queries that are used by default in ASM. The following table identifies and describes the queries.

Note: All Public folders exist by default. Any baseline item in the Baseline folder is also available in the corresponding Public folder. Throughout this documentation, however, we refer to items in the Public folder.

Query	Behavior and Usage
Active_Template_Search	Returns a list of all asset strategy template records that are currently in the Active state.
Asset Strategy Actions Detail	Returns the costs and details of the asset strategy's mitigating actions. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Active Actions Detail	Returns the details of the asset strategy's active mitigating actions. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Active Mitigated Financial Risks Detail	Returns the details of all of the actions that mitigate financial risks for an asset strategy. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Active Mitigated Risks Detail	Returns the details of all the actions that mitigate risks for an asset strategy. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Definition	Returns definition information for a particular asset strategy. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Financial Risks	Returns the financial risks for an asset strategy. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Risk Profile	Returns the risk profile information for an asset strategy. The query is also used to support the Asset Strategy Approval Report.
Asset Strategy Risk Summary	Returns strategy-level risk information. The query is also used to support the Asset Strategy Approval Report.
Asset_Strategy_Search	After prompting you to select a family and a state, returns a list of all asset strategy records that are linked to a record in the selected family and that are currently in the selected state. GE Digital APM runs this query when you search for any strategy in ASM.
Asset_Strategy_Search_Non_Pending	After prompting you to select a family, returns a list of all asset strategy records that are linked to a record in the selected family.
Locate Assets By EAM System For Import	Returns Equipment and Functional Location records where the value in the CMMS System field of the record matches the SAP System of a selected ASI package. The results of this query are displayed in the Asset Strategy Builder when importing SAP objects into ASI.
Locate Assets For Import	Returns a list of equipment records.
Locate Assets For Template Application	Returns assets which belong to a family that can be related to asset strategies and that are not already in a Master Template relationship.
Locate Unlinked Work Management Items For Assets	Returns all work management items, for a specified set of assets, that are not linked to an implementation package.
Strategies Without Master Templates	After prompting you to select a family, returns a list of: asset strategy records that are linked to a record in the selected family but are not linked to an asset strategy template record through the Master Template Has Asset Strategy relationship. Asset strategy records that are not linked to a record and are not linked to an asset strategy template record through the Master Template Has Asset Strategy relationship. GE Digital APM runs this query when you select the Add Existing button on the asset strategy or when you choose to apply an asset strategy template as a master in the Apply Template Builder.
Strategy Asset Families	Returns the list of asset strategy families.
System_Strategy_Search	Returns a list of all system strategy records. GE Digital APM runs this query when you select the System Strategies tab on the ASM Module Overview.
Template_Search	Returns a list of asset strategy templates.
Unit_Strategy_Search	Returns a list of all unit strategy records. GE Digital APM also runs this query when you select the Unit Strategies tab on the ASM Module Overview.