> For the complete documentation index, see [llms.txt](https://docs.videc.de/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.videc.de/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/honeywell-experion-batch-heb/zusaetze.md). # Add-ons In case of errors, a simple diagnosis can be performed on the Honeywell database using PowerShell. PowerShell is part of the Windows operating system. PowerShell Quick Introduction 1. To use PowerShell, launch the IDE. (Run as Administrator) C:\Windows\system32\WindowsPowerShell\v1.0\PowerShell\_ISE.exe {% hint style="info" %} There are 32-bit and 64-bit variants! {% endhint %} 2. The following command must be executed to allow PowerScript execution: Set-ExecutionPolicy Unrestricted Confirm the message with "Yes". Windows now allows the execution of PowerScripts. To test the scripts below, copy the code into a file with the .ps1 extension This file can then be executed in the PowerShell application (ISE). | | | | - | - | \|

# PowerShell Script

# A simple query on a Honeywell Procedure Analyst SQL Server

Function Main{

# Define SQL Server

$SQLServer = "ServerHWE"

$SQLDBName = "ProcedureAnalyst"

$uid ="Admin"

$pwd = "#june5"

# Step 1: Query all databases

$sql1 = @"

SELECT \* FROM sys.databases

"@

# Step 2: Query all events

$sql2 = @"

SELECT TOP 50

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[STARTTIME] AS \[StartTime],

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[ENDTIME] AS \[EndTime],

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[USERPROCEDUREID] AS \[LotNumber],

\[EQUIPMENT].\[FULLNAME] AS \[Namespace],

\[EQUIPMENT].\[NAME] AS \[ItemName],

\[EQUIPMENT].\[EQUIPMENTLEVELNAME] AS \[EquipmentName],

\[PROCEDURAL\_ELEMENT].\[FULLNAME] AS \[ProceduralPath],

\[PROCEDURAL\_ELEMENT].\[PROCEDURELEVELNAME] AS \[ProceduralLevelName],

\[PROCEDURAL\_ELEMENT].\[PHASENAME] AS \[ProceduralPhaseName],

\[PROCEDURAL\_ELEMENT].\[NAME] AS \[ProceduralName],

\[PE\_EVENTS].\[CATEGORYNAME] AS \[EventCategoryName],

\[PE\_EVENTS].\[CONDITIONNAME] AS \[EventConditionName],

\[PE\_EVENTS].\[SUBCONDITIONNAME] AS \[EventSubcondition],

\[PE\_EVENTS].\[SOURCE] AS \[EventSource],

\[PE\_EVENTS].\[PRIORITY] AS \[EventPriority],

\[PE\_EVENTS].\[VALUE] AS \[EventValue],

\[PE\_EVENTS].\[TIMESTAMP] AS \[EventTime],

\[EQ\_PE\_XREF].\[AREANAME] AS \[EventAreaName],

\[PE\_EVENTS].\[DESCRIPTION] AS \[EventDescription],

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[PROCEDUREEXECUTIONID] AS \[ProcExecutionID],

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[PARENTID] AS \[ProcElExecID]

FROM

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC\_EXEC] \[PROCEDURAL\_ELEMENT\_EXECUTION],

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC] \[PROCEDURAL\_ELEMENT],

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_EQ] \[EQUIPMENT],

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_EQ\_PE\_XREF] \[EQ\_PE\_XREF],

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PE\_EVENTS] \[PE\_EVENTS]

WHERE

\[EQ\_PE\_XREF].\[EQUIPMENTID]=\[PROCEDURAL\_ELEMENT\_EXECUTION].\[EQUIPMENTID] AND

\[PE\_EVENTS].\[AREANAME]=\[EQ\_PE\_XREF].\[AREANAME] AND

\[PE\_EVENTS].\[TIMESTAMP]>=\[PROCEDURAL\_ELEMENT\_EXECUTION].\[STARTTIME] AND

\[PE\_EVENTS].\[TIMESTAMP]<=\[PROCEDURAL\_ELEMENT\_EXECUTION].\[ENDTIME] AND

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[PROCEDUREID]=\[PROCEDURAL\_ELEMENT].\[PROCEDUREID] AND

\[PROCEDURAL\_ELEMENT\_EXECUTION].\[EQUIPMENTID]=\[EQUIPMENT].\[EQUIPMENTID]

"@

# Step 3: Query all batches

$sql3 = @"

SELECT TOP 10

\[TPB\_VW\_PROC\_EXEC].\[USERPROCEDUREID] AS \[LotNumber]

,\[TPB\_VW\_PROC\_EXEC].\[STARTTIME] AS \[Start]

,\[TPB\_VW\_PROC\_EXEC].\[ENDTIME] AS \[End]

,\[TPB\_VW\_EQ].\[NAME] AS \[BatchID]

,\[TPB\_VW\_EQ].\[FULLNAME] AS \[Namespace]

,\[TPB\_VW\_PROC\_EXEC].\[DURATION] AS \[Duration]

,\[TPB\_VW\_PROC\_EXEC].\[PROCEDUREEXECUTIONID] AS \[ProductID]

,\[TPB\_VW\_EQ].\[EQUIPMENTLEVELNAME] AS \[UnitBatchID]

FROM

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC\_EXEC],

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC],

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_EQ]

WHERE

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC\_EXEC].\[PROCEDUREID]=\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC].\[PROCEDUREID] AND

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC\_EXEC].\[EQUIPMENTID]=\[ProcedureAnalyst].\[pa].\[TPB\_VW\_EQ].\[EQUIPMENTID] AND

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_EQ].\[EQUIPMENTLEVELNAME]= 'Unit' AND

\[ProcedureAnalyst].\[pa].\[TPB\_VW\_PROC].\[PROCEDURELEVELNAME] = 'Unit Procedure'

"@

# Step 4: Query a database

$sql4 = @"

SELECT \* FROM sys.databases WHERE Name = 'ProcedureAnalyst'

"@

# Execute the individual steps.

MySQLData($sql1)| ft

MySQLData($sql2)| ft

MySQLData($sql3)| ft

MySQLData($sql4)| ft

}

Main

Function MySQLData($sql)

# Function to query SQL data via SQL Client connection

# Integrated Security = SSPI (Windows Authentication)

# Integrated Security = false (SQL Server Authentication)

{

$conn = New-Object System.Data.SqlClient.SqlConnection

$conn.Connectionstring= "Server =$SQLServer; Database =$SQLDBName; Integrated Security = false; User ID =$uid; Password =$pwd;"

$conn.Open()

$cmd = New-Object System.Data.SqlClient.SqlCommand($sql,$conn)

$da = New-Object System.Data.SqlClient.SqlDataAdapter($cmd)

$ds = New-Object System.Data.DataSet

$da.Fill($ds)

return $ds.Tables

$conn.Close()

}

| \| ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | | | | - | - | \|

# PowerShell Script

# A simple query on a Honeywell Procedure Analyst SQL Server via MSOLEDBSQL Provider

Function Main{

# Lists all tables

$sql1 = "SELECT \* FROM sys.tables ORDER BY Name ASC"

# Lists all columns of a table

$sql2 = "SELECT column\_name FROM INFORMATION\_SCHEMA.Columns where TABLE\_NAME = 'TPB\_APPL\_VERSION'"

# Lists all rows of a table

$sql3 = "SELECT \* FROM pa.TPB\_APPL\_VERSION"

MySQLData($sql1)| ft # All tables

MySQLData($sql2)| ft # All columns of a table

MySQLData($sql3)| ft # All rows of a table

}

Main

Function MySQLData($sql)

# Function to query SQL data via MSOLEDDBSQL Provider

{

$conn = New-Object System.Data.OleDb.OleDbConnection

$conn.ConnectionString= "Provider=MSOLEDBSQL;Data Source=ServerHWE;User ID = Admin;Password = #june5;Initial Catalog=ProcedureAnalyst"

$cmd = New-Object System.Data.OleDb.OleDbCommand $sql,$conn

$conn.Open()

$adapter = New-Object System.Data.OleDb.OleDbDataAdapter $cmd

$dataset = New-Object System.Data.DataSet

$adapter.Fill($dataset)

return $dataset.Tables

$conn.Close()

}

| \| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.videc.de/june5-3.7/en/datenquellenunterstuetzung-und-einbindung/honeywell-experion-batch-heb/zusaetze.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.