I would like to update the EndOfSupport info with python but I receive the message no error message but nothing has been updated.
# Orion NodeID
nodeID = '4071'
# Lookup the NCM NodeID, which is a Guid
result = swis.query('SELECT n.Uri, n.NodeProperties.NodeID, n.NodeProperties.CoreNodeID, n.NodeProperties.NodeGroup, n.NodeProperties.NodeComments, n.NodeProperties.Username, n.NodeProperties.Password, n.NodeProperties.EnableLevel, n.NodeProperties.EnablePassword, n.NodeProperties.ExecProtocol, n.NodeProperties.CommandProtocol, n.NodeProperties.TransferProtocol, n.NodeProperties.EncryptionAlgorithm, n.NodeProperties.LoginStatus, n.NodeProperties.UseHTTPS, n.NodeProperties.UseUserDeviceCredentials, n.NodeProperties.LastInventory, n.NodeProperties.AllowIntermediary, n.NodeProperties.TelnetPort, n.NodeProperties.SSHPort, n.NodeProperties.UseKeybInteractiveAuth, n.NodeProperties.ConfigTypes, n.NodeProperties.ConnectionProfile, n.NodeProperties.EndOfSupport, n.NodeProperties.EndOfSales, n.NodeProperties.EndOfSoftware, n.NodeProperties.EosLink, n.NodeProperties.EosType, n.NodeProperties.EosComments, n.NodeProperties.ReplacementPartNumber, n.NodeProperties.OldVulnerabilitiesCount, n.NodeProperties.VulnerabilitiesCount FROM Orion.Nodes n WHERE n.NodeID = @node', node=nodeID)
ncmNodeEOS = '2099-05-10T00:00:00.0000000'
ncmNodeEOSComments = 'SRX210HE'
print('show',ncmNodeEOS, ncmNodeEOSComments)
ncmNodeProperties = {
'NodeID' : result['results'][0]['NodeID'],
'CoreNodeID' : result['results'][0]['CoreNodeID'],
'NodeGroup' : result['results'][0]['NodeGroup'],
'NodeComments' : result['results'][0]['NodeComments'],
'Username' : result['results'][0]['Username'],
'Password' : result['results'][0]['Password'],
'EnableLevel' : result['results'][0]['EnableLevel'],
'EnablePassword' : result['results'][0]['EnablePassword'],
'ExecProtocol' : result['results'][0]['ExecProtocol'],
'CommandProtocol' : result['results'][0]['CommandProtocol'],
'TransferProtocol' : result['results'][0]['TransferProtocol'],
'EncryptionAlgorithm' : result['results'][0]['EncryptionAlgorithm'],
'LoginStatus' : result['results'][0]['LoginStatus'],
'UseHTTPS' : result['results'][0]['UseHTTPS'],
'UseUserDeviceCredentials' : result['results'][0]['UseUserDeviceCredentials'],
'LastInventory' : result['results'][0]['LastInventory'],
'AllowIntermediary' : result['results'][0]['AllowIntermediary'],
'TelnetPort' : result['results'][0]['TelnetPort'],
'SSHPort' : result['results'][0]['SSHPort'],
'UseKeybInteractiveAuth' : result['results'][0]['UseKeybInteractiveAuth'],
'ConfigTypes' : result['results'][0]['ConfigTypes'],
'ConnectionProfile' : result['results'][0]['ConnectionProfile'],
'EndOfSupport' : ncmNodeEOS,
'EndOfSales' : result['results'][0]['EndOfSales'],
'EndOfSoftware' : result['results'][0]['EndOfSoftware'],
'EosLink' : result['results'][0]['EosLink'],
'EosType' : 2,
'EosComments' : ncmNodeEOSComments,
'ReplacementPartNumber' : result['results'][0]['ReplacementPartNumber'],
'OldVulnerabilitiesCount' : result['results'][0]['OldVulnerabilitiesCount'],
'VulnerabilitiesCount' : result['results'][0]['VulnerabilitiesCount']
}
print('show',ncmNodeProperties)
# Commit changes
swis.update('Cirrus.Nodes', 'UpdateNode', ncmNodeProperties)
Any ideas? Thanks!