Creating a Change History Query - PAS Integrity Software Suite - 7.3 - Help - Intergraph

Integrity Help

Language
English
Product
PAS Integrity Software Suite
Subproduct
Cyber
Search by Category
Help
PAS Version
7.3

You can use a change history query to search for objects that were added or removed. You can also search for objects with modified property values. The query criteria allow you to define object types, properties, the time period to check, and more.

To create and save a change history query:

  1. Click Queries > Create/Edit Queries in the left navigation bar.

  2. In Asset, select an asset for which you want to create the query. If you are creating a query for more than one asset of a specific type, select one asset of that type. The query will be listed for the asset you select.

  3. Click Create Query. The new query settings and criteria options are displayed in the right pane.

  4. In Query Type in the right pane, select Changes.

  5. In For Objects of Type in the right pane, select the type of objects you want to include in the query.

  6. In Change Type, check the check box for each type of change you want to include in the query. If you do not check at least one change type (Added, Modified, or Deleted), Integrity includes all change types in the query.

  7. If you want to run this query against a list of assets in addition to the asset you selected, complete the following steps:

    1. Click From Asset(s). The Assets window is displayed.

    2. In Available Assets, select the assets you want to include in the query, and then click >. The selected assets are listed in Included Assets.

    3. Close the Assets window.

  8. If you want to select the properties to include in the query results, complete the following steps. If you do not select any properties, Integrity includes all properties as columns in the results and sorts the results by object name.

    1. Click Property Names. The Property Names window is displayed.

    2. In Property names, select each property you want to include in the results, and then click on the right arrow (>) to add the property to the Included in results list.

    3. In Included in results, use the up and down arrow buttons below the list to set the order of the columns in the query results.

    4. If you want to modify the sort order, click each property in Included in results you want to use to sort the results, and then click the right arrow (>) to add the property to the Sort By list. By default, Integrity sorts the results by object name.

    5. In Sort By, use the up and down arrow buttons below the list to set the sort order for the query results.

    6. Close the Property Names window.

  9. Complete the following steps to filter the query results by time period or selected imports:

    1. Click Import Summary. The Import Summary window is displayed.

    2. If you want query data between two dates, in Query by, select Date Range. Then, specify the start and end dates and times to define the range of time you want to include in the results and click Update.

    3. If you want query data during a period of time up until now, in Query by, select Rolling Range. Then, specify the number of days from the current data to define the range of time you want to include in the results and click Update.

    4. If you want query data during a specific data import, in Query by, select Import Summary. Then, select the imports you want in Available imports and click the right arrow (>) to identify the imports you want to include in the results. Those imports are listed in Chosen imports.

    5. Close the Import Summary window.

  10. If you want to add more filters based on properties, complete the following steps:

    You can add filters based on properties and a selection list that defines a list of objects.

    1. Click Search Criteria.

    2. Click Select from properties.

    3. Add a filter criteria expression by typing a value in one or more of the Object Name, Property Name, Old Value, New Value, Ack , and Comment fields, and then click Add New. For example, to include only objects with a name similar to TPS25 and unacknowledged changes, type TPS25 in the Object Name field and select False in the Ack field.

    4. If you want to add more filter criteria expressions, repeat the previous step as many times as needed. By default, Integrity uses AND to combine and evaluate all the criteria expressions. You can select expressions and then click GROUP AND or GROUP OR to change how expressions are evaluated together.

    5. When you are done specifying the property-based filter criteria you want, close the Search Criteria window.

  11. If you want to add more filters based on a list of objects, complete the following steps:

    1. Click Search Criteria.

    2. Click Use selection list. The Available objects list includes all the objects you can select.

    3. If you want to create a saved list of objects that you can reuse, in Select list name, click Add New, and then type the new selection list name. In Available objects, select the objects you want, and click the right arrow (>) to add them to List details. Then, click Save List.

    4. If you want to use an existing saved list of objects, in Select list name, click the name of the selection list you want.

    5. If you want to modify an existing saved list of objects, in Select list name, click the name of the selection list you want. Modify the list as needed, and then click Save List to overwrite the saved list.

    6. If you want to add a typed list of objects to the List details field, copy a list of object names you want separated by spaces, commas, semicolons, or the pipe (|) character to the Windows clipboard, then click the clipboard icon at the top right of the List details field.

    7. If you want to search for the objects you want, type a search string using wildcard characters, such as *24*, in the Available objects field, and then click the magnifying glass icon to display a list of matching objects.

    8. If your search does not provide the results you want, delete the text in the Available objects field or type a new value and click the magnifying glass icon again.

    9. Select one or more objects from the Available objects list, and then click the right arrow (>) to move the selected objects to the List details field.

    10. Click Add Criteria to add the list of objects to the search criteria. If a list was previously added the criteria, or if you make additional changes, click Update Criteria.

    11. When you are done specifying the selection list-based filter criteria you want, close the Search Criteria window.

  12. Click Run, and then review the results to make sure the query provides the results you want.

  13. Click Save As. The Save Query pane is displayed.

  14. In Enter a query name, type the name of the new query.

  15. Select whether to make the query Public or Private.

  16. If you want the query to be available for all assets of this type, check Save with Asset Model.

  17. Click OK.

  18. Click OK on the confirmation message.

Now you can run the query or use it as a basis for a report. For more information, see Running a Query.