R8289 - Pending MAC constant alert

[MRCUR]

R8289/SVN5772 - The pending MAC alert is always showing. Clicking the link in the alert to go to the report screen results in no computers being returned “No results found”. Clicking the “approve all” button does make the popup go away.

[Wayne Workman]

In the hostMAC table (I think), there’s a column for pending. You can set that whole column to 0 I think to solve this. Can’t help you with the SQL at the moment because I’m away from computers.

[Tom Elliott]

SQL to fix pending:

UPDATE hostMAC set hmPending='0';

[MRCUR]

@Tom-Elliott Thanks Tom. I’ll use that if the alert returns with the blank host report. It’s not come back since I did “approve all” a few hours ago.