PREFIX BASE: <http://schemas.ogf.org/nml/2013/05/base#>
PREFIX ndl-topology-owl: <http://cinegrid.uvalight.nl/owl/ndl-topology.owl#>
PREFIX sdndl: <http://www.gsi.dit.upm.es/ontologies/sdndl#>
PREFIX sdndlcao: <http://www.ctb.upm.es/ontologies/sdndlcao#>
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT DISTINCT STR(?vlan_id) AS ?vlan_id
                STR(?node_ip_address) AS ?node_ip_address
                STR(?timestamp_dist_node_scan_start) AS ?timestamp_dist_node_scan_start
                STR(?timestamp_dist_node_scan_end) AS ?timestamp_dist_node_scan_end
                STR(?timestamp_device_scan_start) AS ?timestamp_device_scan_start
                STR(?timestamp_device_scan_end) AS ?timestamp_device_scan_end
                STR(?mac_address) AS ?mac_address
                STR(?mac_manufacturer) AS ?mac_manufacturer
                STR(?ip_address) AS ?ip_address
                STR(?operating_system) AS ?operating_system
                STR(?hostname) AS ?hostname
                STR(?port) AS ?port
                STR(?SERVICE) AS ?SERVICE
                STR(?service_version) AS ?service_version
                STR(?discovery_method) AS ?discovery_method
                STR(?state) AS ?state
                STR(?protocol) AS ?protocol

WHERE
      {
      ?snapshot_instance sdndlcao:snapshotId "098f6bcd4621d373cade4e832"^^xsd:string;
                         sdndl:isSnapshotOf ?interface_instance;
                         sdndlcao:snapshotOfScanningDevice ?scanningDevice_instance;
                         sdndlcao:snapshotOfDevice ?device_instance;
                         sdndlcao:snapshotOfDiscoveringService ?discoveringService_instance.

      ?interface_instance sdndlcao:vlanId ?vlan_id;
                          sdndl:ipAddress ?node_ip_address.

      ?scanningDevice_instance sdndlcao:timestampScanStart ?timestamp_dist_node_scan_start;
                               sdndlcao:timestampScanEnd ?timestamp_dist_node_scan_end.

      ?device_instance sdndlcao:timestampScanStart ?timestamp_device_scan_start;
                       sdndlcao:timestampScanEnd ?timestamp_device_scan_end;
                       sdndl:hardwareAddress ?mac_address;
                       sdndlcao:macManufacturer ?mac_manufacturer;
                       sdndl:ipAddress ?ip_address;
                       sdndlcao:operatingSystem ?operating_system;
                       sdndlcao:hostname ?hostname.

      ?discoveringService_instance sdndlcao:discoveringServiceOfService ?service_instance;
                                   sdndlcao:serviceVersion ?service_version;
                                   sdndlcao:discoveryMethod ?discovery_method;
                                   sdndlcao:state ?state;
                                   sdndlcao:protocol ?protocol.

      ?service_instance sdndl:portNumber ?port;
                        sdndlcao:serviceName ?SERVICE.
      }