Language: Chinese

Datebase: postgresql-17.6-1-windows-x64.exe

ODBC: psqlodbc_x86.msi

SQL: 

/* I just added IF exists to the official SQL script statement, nothing else changed */

DROP TABLE IF exists Item;
DROP TABLE IF exists Report;
DROP TABLE IF exists NextID;

CREATE TABLE Report (
  ID             INT PRIMARY KEY,
  RVersion       VARCHAR(255),
  RHost          VARCHAR(255),
  RHostComment   VARCHAR(255),
  RUser          VARCHAR(255),
  RLocation      VARCHAR(255),
  RDateTime      VARCHAR(16),
  RComplete      SMALLINT
);

CREATE TABLE Item (
  INum           INT,
  IPage          VARCHAR(100),
  IDevice        VARCHAR(255),
  IGroup         VARCHAR(255),
  IField         VARCHAR(255),
  IValue         VARCHAR(255),
  IIcon          INT,
  IID            INT,
  ReportID       INT NOT NULL,
    
  CONSTRAINT     cnstI1 FOREIGN KEY(ReportID) REFERENCES Report(ID)
);

CREATE TABLE NextID (
  TableName      VARCHAR(6) PRIMARY KEY,
  NextID         INT NOT NULL
);

INSERT INTO NextID (TableName, NextID) VALUES ('Report', 1);
 

Error message: 

失败
警告：插入报告时出现错误！
错误：关系“item”不存在；
Error while preparing parameters
INSERT INTO Item
(INum,Ipage,IField,IValue,IIcon,IID,ReportID) VALUES (1,'报告','版本','AIDA64 v7.70.7500/cn',0,257,0)

The Chinese error message is translated as follows:
Failed
Warning: Error occurred while inserting report!
Error: Relation "item" does not exist;

I'd also like to know if the main program in AIDA64 is still 32-bit? Only some of the 64-bit test programs are 64-bit. XP is the only 32-bit operating system left, and in actual production environments, they're almost nonexistent. Even if they do exist, the number is so small that it doesn't affect data collection. When will a fully native 64-bit AIDA64 be released?

PostgreSQL no longer has a 32-bit version. The ODBC driver needs to have the same bitness as the main AIDA64 program. Checking in Task Manager shows that AIDA64 is 32-bit. What did I do? I first used the latest version of AIDA64 to export a CSV report, and then when I tried to import the CSV report from AIDA64's database manager, an error occurred. I tried multiple times, but the error persists. I asked AI, "Maybe AIDA64 is mixing up the uppercase and lowercase letters in the data tables. Have you tested this?" PostgreSQL databases are case-sensitive. What do I ultimately want to do? My Access database keeps getting corrupted after running for a while. I want to install PostgreSQL and, in the AD domain, use a policy to execute a command line to collect system information at startup and send it to the PostgreSQL database.

[root@skynet tmp]# cat /etc/redhat-release
Fedora release 27 (Twenty Seven)
[root@skynet tmp]# lshw -version

the latest version is B.02.17
[root@skynet tmp]# ./aida64_x64
Cannot find 'lshw' command! Please install lshw package!
[root@skynet tmp]#

So what is the problem??

I have one network with 20 computers (in domain or not in domain - Does it matter?)

I have 1 server - Windows Server 2003 x86/ Windows Server 2008 R2

I have 19 desktop PCs - Windows XP 32bit / Windows7 32bit/64bit

I have 20 AIDA64 Business Edition License

I would like to collect only hardware data from the desktop PCs to the server in one shared directory in one file or separeted files. What format is the best for this?

Every month I would like to open the report file and see the hardware changes.

How can i solve this?

Thanks for the answer!

The company where I work uses the AIDA64 Business version. Unfortunately, we find that the audit manager module does not show the physical memory data of the clients. (In the full report the data is correctly visible). I would like to ask for help to solve this.

For example:

Thanks,

Juhasz Janos

c/KaanBoğa

Sensörpanel.zip

Composition of my "myset.rpf"

ReportProfile="Custom"
ProfileFile=""
ReportFormat="csv"
RemoteReportFolder="C:\Users\Sektor\Documents\AIDA64 Reports"
RemoteReportFileName="$HOSTNAME"
InfoPage="Computer;Sensor"
 

I need only "Computer;Sensor;Temperatures;CPU"

How i can create my "myset.rpf" that give infopage with only temperatures CPU ?

All my reports are placed in the database, but the problem is that I want to make a transposition of information, and from the item table where monitors are described for example, make a table reference for all monitors on computers.
That is a unique reference table
The problem is that it happens for some reason when two monitors are connected to the computer, but they differ slightly in characteristics (quite a bit, but they are still different)
So I get this way I can not distinguish them as they are different monitors.
I can determine their uniqueness by a set of values of certain fields, but in this case, as if the item table does not have a column with the number of the monitor instance (like ISequel), so that it was possible to group monitor instances by it

Please tell me what the RLocation field in the database means? I have always empty, and for the sake of interest where the information is taken put

The RComment field, as I understand it, is the computer description field in the computer properties.

Good day! I implement aida64be software for monitoring and collecting information in a domain. Set up a domain policy. The script looks like: / R / CSV / CUSTOM [\\ test-aida-001 \ C $ \ Shares \ AIDA64 \ aida64.rpf] / CSV2SQL [\\ test-aida-001 \ C $ \ Shares \ AIDA64] / ACCEPT / SAFE / SILENT. Reports to the database do not automatically fall. Have a name consisting of date and time. I do not see the name of the computer in the report. When loading reports into the database, I see only three tables. "Item", "ID", "Report". In the "Report" contains only a list of reports and all. The "Item" contains a detailed report, not the client PCs, but the server on which the AIDA64BE is installed. What am I not setting up or doing?

Use Windows Authentication is unchecked

User: DoesntMatter

Password: DoesntMatter.

Clicking "Test" always works if the windows account is allowed access to SQL Server.

I verified this by observing the credentials used by monitoring SQL Profiler.  Aida64 always uses the current windows account.

At first, here: https://www.aida64.com/linux-extension-aida64  is written "The software can be easily deployed in a corporate environment by following the instructions in the Setup Guide, which is downloadable from our website" - but I was not able to find this Setup Guide on your website.

I tried to use AIDA Linux extension on my Ubuntu linux machine and some information is missing. I don't know if it is correct or not, but this information is available. I ran  sudo ./aida64_x64 command locally.

CSV file:

Summary,,Display,525,Monitor,Unknown

get-edid | parse-edid output:

Section "Monitor"
        Identifier "20WGX2"
        ModelName "20WGX2"
        VendorName "NEC"
        # Monitor Manufactured week 48 of 2007
        # EDID version 1.3
        # Digital Display
        DisplaySize 430 270
        Gamma 2.20
        Option "DPMS" "true"
        Horizsync 31-83
        VertRefresh 56-75
        # Maximum pixel clock is 170MHz
        #Not giving standard mode: 1280x720, 60Hz
        #Not giving standard mode: 1280x960, 60Hz
        #Not giving standard mode: 1280x1024, 60Hz
        #Not giving standard mode: 1440x900, 60Hz
        #Not giving standard mode: 1400x1050, 60Hz
        #Not giving standard mode: 1680x1050, 60Hz
        #Not giving standard mode: 1152x864, 75Hz
        Modeline        "Mode 0" 146.25 1680 1960 2136 2240 1050 1053 1059 1089 -hsync +vsync
EndSection

CSV file: names truncated:

Summary,,Storage,528,Disk Drive,WDC WD60EZRZ-00G
Summary,,Storage,528,Disk Drive,MK001920GWCFB
Summary,,Storage,528,Disk Drive,Crucial_CT512M55

hdparm -I (just part of the report)

        Model Number:       WDC WD60EZRZ-00GZ5B1
        Serial Number:      WD-WX61DA6PZHNR
        Firmware Revision:  80.00A80

        Model Number:       MK001920GWCFB
        Serial Number:      S3BPNY0J308921
        Firmware Revision:  HPG0

        Model Number:       Crucial_CT512M550SSD1
        Serial Number:      14140C10B4DB
        Firmware Revision:  MU02

CSV file: all DMI "Unknown"

sudo dmidecode shows:

# dmidecode 3.1
Getting SMBIOS data from sysfs.
SMBIOS 2.6 present.
109 structures occupying 4808 bytes.
Table at 0x000F21D0.

BIOS Information
        Vendor: Dell Inc.
        Version: A15
        Release Date: 05/08/2017
        Address: 0xF0000
        Runtime Size: 64 kB
        ROM Size: 10240 kB
        Characteristics:
                PCI is supported
                BIOS is upgradeable
                BIOS shadowing is allowed
                Boot from CD is supported
                Selectable boot is supported
                EDD is supported
                5.25"/1.2 MB floppy services are supported (int 13h)
                3.5"/720 kB floppy services are supported (int 13h)
                3.5"/2.88 MB floppy services are supported (int 13h)
                Print screen service is supported (int 5h)
                8042 keyboard services are supported (int 9h)
                Serial services are supported (int 14h)
                Printer services are supported (int 17h)
                ACPI is supported
                USB legacy is supported
                BIOS boot specification is supported
                Function key-initiated network boot is supported
                Targeted content distribution is supported
        BIOS Revision: 4.6

System Information
        Manufacturer: Dell Inc.
        Product Name: Precision T3600
        Version: 01
        Serial Number: 8C8RJZ1
        UUID: 4C4C4544-0043-3810-8052-B8C04F4A5A31
        Wake-up Type: Power Switch
        SKU Number: Not Specified
        Family: Not Specified

Base Board Information
        Manufacturer: Dell Inc.
        Product Name: 08HPGT
        Version: A02
        Serial Number: /8C8RJZ1/CN7220039701AL/
        Asset Tag: Not Specified
        Features:
                Board is a hosting board
                Board is replaceable
        Location In Chassis: Not Specified
        Chassis Handle: 0x0003
        Type: Motherboard
        Contained Object Handles: 0

Physical Memory Array
        Location: System Board Or Motherboard
        Use: System Memory
        Error Correction Type: Multi-bit ECC
        Maximum Capacity: 64 GB
        Error Information Handle: Not Provided
        Number Of Devices: 4

Memory Device
        Array Handle: 0x002E
        Error Information Handle: No Error
        Total Width: 72 bits
        Data Width: 64 bits
        Size: 8192 MB
        Form Factor: DIMM
        Set: None
        Locator: DIMM1
        Bank Locator: Not Specified
        Type: DDR3
        Type Detail: Registered (Buffered)
        Speed: 1600 MT/s
        Manufacturer: Samsung-00CE
        Serial Number: 1345F804
        Asset Tag: 031327
        Part Number: M393B1G70BH0-YK0
        Rank: 1

CSV file:

CPU,,CPU Manufacturer,0,Product Information,Unknown

lscpu output:

Architecture:        x86_64
CPU op-mode(s):      32-bit, 64-bit
Byte Order:          Little Endian
CPU(s):              8
On-line CPU(s) list: 0-7
Thread(s) per core:  2
Core(s) per socket:  4
Socket(s):           1
NUMA node(s):        1
Vendor ID:           GenuineIntel
CPU family:          6
Model:               45
Model name:          Intel(R) Xeon(R) CPU E5-1620 0 @ 3.60GHz
Stepping:            7
CPU MHz:             1197.019
CPU max MHz:         3800,0000
CPU min MHz:         1200,0000
BogoMIPS:            7183.09
Virtualization:      VT-x
L1d cache:           32K
L1i cache:           32K
L2 cache:            256K
L3 cache:            10240K
NUMA node0 CPU(s):   0-7
Flags:               fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe s    yscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts rep_good nopl xtopology nonstop_tsc cpuid aperfmperf pni pclmulqdq dtes64 monit    or ds_cpl vmx smx est tm2 ssse3 cx16 xtpr pdcm pcid dca sse4_1 sse4_2 x2apic popcnt tsc_deadline_timer aes xsave avx lahf_lm epb pti ssbd ibrs     ibpb stibp tpr_shadow vnmi flexpriority ept vpid xsaveopt dtherm ida arat pln pts flush_l1d

Apparently much more information could be added to the report.

Petr

I have collected info about 20 PC in database.

Can I make report about only 5 selected computers?

Thanks :)

1. In preferences you can set an inclusion date range for changes.  When applied,  (clicking the refresh button, or start),  it appears to be looking at reports far outside the date range.  This dramatically increases the time it takes to generate the report. The output is correct, just takes longer that it should.  Maybe filter out reports outside the date range when it is generating the report?

2. Need a better way to 'include' computers in a report.  Currently the only option is to 'exclude'.  This is very time consuming if you have 25 computers,  and only want a report on 4 of them.  Maybe a checkbox selection list?

3. I can't seem to find a list of changes that were 'authorized'  Perhaps add that as a column  "Authorized  Y/N"  or something? Maybe add a filter. "Only show authorized/unauthorized changes" This one is pretty important.

4. Related to #2,  On the 'Computer' tab,   right click on a specific computer (or possibly multiple computers),  then choose Quick Report.  This should only apply to the computer that is selected,  not all in the list.

Thanks for your consideration :-)

a question about using the Business version for collecting data from, or managing a remote Linux system.

Is the connection to the remote system encrypted and if so, what form of encryption is used?

Thanks,

On one client we have the problem that the client creates reports every 10-30 min. During the test and creating the report, the clients is extremely slow.

The frequenze of report creation is "One a day" but we can find every report in the SQL Datebase.

What´s to do, to stop the testing/reporting every 10-30min?

What to do?

If user doesn't have admin rights on Windows 7 - report created without any confirmation, this mean what there is a way to make job and not ask any questions.

But when user is admin aida64 request elevation.

Can you add some command line key or .ini settings to disable elevation and make job on user level ?

PS: I tried "runas /trustlevel:0x20000 aida64.exe" but get error 740.

I'm running AIDA64 remotely.  I've created an .rpf where I chose

Computer

      -Computer Name

      - DMI

Motherboard

      - BIOS

Operating System

      - Operating System

Software

      - Installed Programs

Security

      - Windows Update

I generate all my report files, and then start Audit Manager on the central server where AIDA64 is installed.

I "Add Report Files" and select all my rpf files.

When I look at the resultant output in Audit Manager - I don't see any BIOS information.  But the information is in the csv files?

I've attached a sample csv file,  my rpf file and a screenshot of the Audit Manager report....

please rename    

CIPReport_rpf.txt         to          CIPReport.rpf

and

XXXX_CIP_2016-03-17_10-26-07_csv.txt       to        XXXX_CIP_2016-03-17_10-26-07.csv

ALSO - Is there a way to have ONLY the BIOS Version and BIOS Type reported instead of all 11 records under BIOS???

Thanks

cindy

CIPReport_rpf.txt

XXXX_CIP_2016-03-17_10-26-07_csv.txt

Is there a way to automate obsolete reports deletion? We want to keep results of a last scan only.

Best regards,

Gregory.