[SOLVED] Deleting History OR in WAPT

[Geoffroy]

Good morning,

We have had several workstations that broke down during this year.
We are currently rebuilding our AD directory structure and some OUs that are empty in the AD continue to appear in the WAPT inventory even though there are no longer any workstations inside them.

When I run this command in the reporting, I get some items that appear

Code: Select all

SELECT * from Hosts WHERE (hosts.computer_ad_ou ILIKE '%%OU=toto,DC=mydom,DC=lan')

Except that the workstation that this command brings up will never be turned on again and it no longer exists anywhere in our AD but remains present but not visible in the WAPT OUs.

No filter is applied to the OUs and this PC does not appear in the inventory of all workstations.

How do I get rid of these ghost jobs?

[dcardon]

Hello Geoffroy,
Do you have ACLs that limit the visibility of workstations? We can add ACLs that restrict visibility to only the workstations we can access (i.e., those where your certificate is deployed). ACLs are managed in the "Tools" menu / "WAPT User and Rights Management".
If there are no ACLs, there might be a bug in the DN value reporting. Could you try the following query:

Code: Select all

select  uuid, host_info->'computer_ad_dn' , hosts.computer_ad_ou from Hosts
WHERE (hosts.computer_ad_ou ILIKE '%%OU=toto,DC=mydom,DC=lan')

And to verify that the OR corresponds to the DN of the machine input. And here I'm a bit stuck. In the meantime, you can delete it with a

Code: Select all

DELETE FROM Hosts where uuid='xxxxxxxxxxxxxxxxxxxxxx'

It must be launched directly on the database with the psql tool, because the query editor in the WAPT console is only allowed to perform SELECT queries.

Sincerely,
Denis