ASM Queries

The main ASM Catalog folder is \\Public\Meridium\Modules\Asset Strategy Management\Management. This folder contains a subfolder, Queries, which contains baseline queries that are used by default in ASM.

If desired, you can store additional items in the main ASM Catalog folder or in the Queries subfolder. In addition, you can create new subfolders to store additional items.

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_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. Meridium Enterprise 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 for Import	Returns a list of Equipment records.
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. Meridium APM runs this query when you click 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.
System_Strategy_Search	Returns a list of all System Strategy records. Meridium Enterprise APM runs this query when you click the System Strategies tab on the ASM Module Overview.
Unit_Strategy_Search	Unit_Strategy_Search Returns a list of all Unit Strategy records. Meridium Enterprise APM also runs this query when you click the Unit Strategies tab on the ASM Module Overview.