hp-support-head-portlet

Actions
Loading...
HP Customer Support - Knowledge Base

hp-contact-secondary-navigation-portlet

Actions
Loading...

hp-share-print-widget-portlet

Actions
Loading...
  • Information

    Fix and resolve Windows 10 update issue on HP Computer or Printer. Click here

    Information

    Audio or sound issues? Try our automated HP Audio check!

    Information
    Create an HP account today!

     Connect with HP support faster, manage all of your devices in one place, view warranty information and more. Learn more​

hp-concentra-wrapper-portlet

Actions
Loading...

HP Access Control Job Accounting - SQL Query mode does not display years later than 2020

Learn about an issue involving missing years in the Database Manager for HP Access Control when running a query in parameterized mode.

SQL Query mode does not have years later than 2020

Follow these steps to learn about and solve the issue.

Issue

When running a query in parameterized mode using the SQL Query mode option in HP Access Control Database Manager or SQL Management Studio, the last year available for selection is 2020, and years 2021 and later are not available for selection.

HP Access Control, SQL Query mode; 2020 is highlighted as last year available

Solution

Run the following script(s) in Database Manager or SQL Management Studio.

  1. Login into Database manager using Windows or SQL credentials.

    HP Access Control Database manager; login screen
  2. Select SQL query mode from the Database menu.

    HP Access Control Database manager; selecting the 'SQL query' option
  3. Copy and run the script to modify the dates.

    Script text to copy/paste
    • Use HPACJA

    • Update T_DefaultValue set lab_Value = '2010-01-01 00:00:00' where lab_Name = 'DEF_DATE_START'

    • Update T_DefaultValue set lab_Value = '2030-12-31 23:59:59' where lab_Name = 'DEF_DATE_END'

  4. Wait for the Results pane to display the status 2 row(s) affected.

    HP Access Control SQL Query window in Database manager; Results pane listing '2 row(s) affected' status
  5. Select Disconnect from the Database menu to log off from Database manager.


hp-feedback-input-portlet

Actions
Loading...

hp-feedback-banner-portlet

Actions
Loading...

hp-country-locator-portlet

Actions
Loading...
Country/Region: Flag New Zealand

hp-detect-load-my-device-portlet

Actions
Loading...