I need a SQL Query to notify changes in Hard Disk: Altiris 7.1

[edwardortegas]

Hello,

Turn to their experience in order to get help on the following topic:

I need to generate a query to notify me changes hard drive size on the stations that have Altiris agent version 7.1.

I have now a report that notifies me memory changes I share this to see if it can generate the alert.

select

IA.Name [Computer],

doc. [User] [user]

doc.Domain [Domain]

ia. [Operating System] [Operating System]

IA. [Computer Model] [Model]

IA. [Memory (MB)] as 'memory Parametro Previous'

IH. [Memory (MB)] as 'Parametro current memory'

IH. [Serial number] [Serial]

IA. [IP Address] as 'IP Address'

-------------------------------------------------- ---------------

CASE

WHEN doc. [IP Address] like '10 .16.33.% 'THEN' BOGOTA '

WHEN doc. [IP Address] like '10 .16.34.% 'THEN' ANTIOCH '

WHEN doc. [IP Address] like '10 .16.37.% 'THEN' BARRANQUILLA '

 WHEN doc. [IP Address] like '10 .16.50.% 'THEN' MONTERÍA-CORDOVA '

WHEN doc. [IP Address] like '10 .16.51.% 'THEN' Necoclí-ANTIOCH '

END [Location]

dbo.temp_InventarioAyer from IA

dbo.vInventarioActual join IH on IA.guid = IH.guid

vComputer join doc on IA.guid = doc.guid

Where IA. [Memory (MB)]> IH. [Memory (MB)]

and IA. [Operating System] not like '% server%' and IA. [Serial Number] is not null

Thank you.
 

[Igor Perevozchikov]

You can use SQL Query from default "Computers with Hardware Changes" report.

1. To see data in "Computers with Hardware Changes" report, you need to open a "Resource History" page on SMP Console and check "Physical Memory", "Processor" and "Storage" for "Inventory Solution"

2. Clone "Computers with Hardware Changes" report and then click "Edit" ⇒ copy SQL Query from this report.

If you want to receive this report content by mail, then you can check steps for automation policy creation with mail notification, described in this article

• https://www-secure.symantec.com/connect/articles/auto-notification-about-agent-service-crash-mail-and-further-connection-client

Thanks,

IP.

[edwardortegas]

Hello good day,

I was validating the information you send me to the subject of data in "Computers With Hardware Changes", these changes and have the tool.

On the subject "Computers With Hardware Changes" I share the query and performs mail notifications are perfect.

The specific issue is that I can not arrive me notifications of changes hard drive, I get only the memory, and reach the mail correctly.

Could you advise me with sql attached you if it serves to drive these changes are notified or another query that does.

thank you.

Attachment(s)

Evento de Hardware ACR.txt   4 KB 1 version