PI Adapter for OPC UA Discovery file attributes setting

Hello Jiyeon,

I���m using this in order to get the Discovery:

edgecmd get discoveries -cid PIR-PIOPCUA301 -id NodeIds-PIR-PIOPCUA301 -result -file C:\Adapter\NodeIds-PIR-PIOPCUA301.csv -csv -autoSelect false

The file looks like this:

[cid:image002.png@01DAE982.423E4B50]

What to do in order to get a file without columns ���selected,name,streamId,dataFilterId��� ?

First question ��� is it possible to

Best regards,

Ivan Lozanov
Automation engineer
Automation Department

Phone.: +359 728 6 2453
Mobile: +359 88 9631978
Mail: i.lozanov@aurubis.com

Aurubis Bulgaria AD
Industrial zone
BG - 2070 Pirdop
Website: www.aurubis.com

[cid:image001.png@01DAE981.641D0F50]

Hello Jiyeon,

I have open a case ��� please see the attachment.
The answer is that is not possible to set what attributes the Discovery will return.

Best regards,

Ivan Lozanov
Automation engineer
Automation Department

Phone.: +359 728 6 2453
Mobile: +359 88 9631978
Mail: i.lozanov@aurubis.com

Aurubis Bulgaria AD
Industrial zone
BG - 2070 Pirdop
Website: www.aurubis.com

[cid:image001.png@01DAE7FD.286523B0]

Hello Jiyeon,

Please check the attached case.
Is that right?

Best regards,

Ivan Lozanov

Automation engineer

Automation Department

Phone.: +359 728 6 2453

Mobile: +359 88 9631978

Mail: i.lozanov@aurubis.com

Aurubis Bulgaria AD

Industrial zone

BG - 2070 Pirdop

Website: www.aurubis.com

[cid:a3f15ba7-d039-4689-913b-83bad84bf4ca]

Hello Jiyeon,

Do you mean change something int the file ���PIR-PIOPCUA301_Discoveries.json��� ?

To add discoveries I am using this:
edgecmd add discoveries -cid PIR-PIOPCUA301 -id NodeIds-PIR-PIOPCUA301 -query "RootNodeIds=ns=1;s=f|OS3_OS::List of all tags"

To generate the file ���NodeIds-PIR-PIOPCUA301.csv��� I am using this:
edgecmd get discoveries -cid PIR-PIOPCUA301 -id NodeIds-PIR-PIOPCUA301 -result -file C:\Adapter\NodeIds-PIR-PIOPCUA301.csv -csv

[cid:image003.png@01DADE76.64120260]

Is it possible to remove columns ���selected,name,streamId,dataFilterId��� ?

Is it possible to add other attribute column to this file?
For example ���StatusCode���:

[cid:image004.png@01DADE78.5150E9F0]

[cid:image002.png@01DADE75.381E7130]

Best regards,

Ivan Lozanov
Automation engineer
Automation Department

Phone.: +359 728 6 2453
Mobile: +359 88 9631978
Mail: i.lozanov@aurubis.com

Aurubis Bulgaria AD
Industrial zone
BG - 2070 Pirdop
Website: www.aurubis.com

[cid:image001.png@01DADE73.5B1AA890]

Thank you for your feedback. If I've missed the nature of your feedback with what I've shared below, please do let me know in a follow-up comment.

With the Discovery option, it will capture the information that is readily available in the OPC UA server. The "name" and "dataFilterId" properties are ones that you can specify (optional). If you would prefer to manually change this information before you push it into Data Selection configuration, you can add the following line to your Discovery request:

"autoSelect" : false

For example:
{
"id" : "SampleId",
"query" : "RootNodeIds=ns=1;s=MyDevice",
"autoSelect" : false
}

Assuming you've installed the adapter on a Windows device, the exported configuration file can be found in your %programdata%/OSIsoft/Adapters/OpcUa/Configurations folder. You can open the json file and modify those parameters as you see fit. You can also use EdgeCmd Utility to export it as a .csv file to more easily update it using applications such as Excel. Once you've made the appropriate modifications, you can use EdgeCmd again to pull in the .csv file (or json file if you choose to stick to that format) into your Data Selection configuration. It looks like we do not provide an example of this in our documentation - I will work with our tech writers to update it with more details.