RE: [External] [mssms] RE: Prevent custom hardware inventory class from keeping history?

[Daniel Ratliff]

Perfect!! Thanks everyone.

Daniel Ratliff


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Sherry Kissinger
Sent: Wednesday, November 1, 2017 10:52 AM
To: mssms@lists.myitforum.com
Subject: Re: [External] [mssms] RE: Prevent custom hardware inventory class 
from keeping history?

I can't say what company I work for but... 
https://mnscug.org/blogs/sherry-kissinger/357-configmgr-2012-truncate-history-tables
we run that every night on our sql servers that have a CM database.

On Wed, Nov 1, 2017 at 9:06 AM, Miller, Todd 
<todd-mil...@uiowa.edu<mailto:todd-mil...@uiowa.edu>> wrote:
I think I remember hearing about an site – was it Welles Fargo?-- that was 
running a SQL maintenance task to truncate ALL their history tables in 
Configmgr.  I am not sure if it has to be an all or nothing thing.  It might be 
possible to just truncate the history table for that one thing in SQL as a 
maintenance task.


(nice disclaimer notification, by the way.   These things are getting out of 
hand, eh?)


From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com>] 
On Behalf Of Daniel Ratliff
Sent: Wednesday, November 01, 2017 8:38 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [External] [mssms] RE: Prevent custom hardware inventory class from 
keeping history?

Thanks Garth! We added some custom inventory a few weeks ago to track some 
specific event logs, and the HINV history tables are upwards of 300GB. Way 
larger than we were expecting. Fun times.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, November 1, 2017 8:58 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Prevent custom hardware inventory class from keeping 
history?

Hi Daniel, I know of no way to do this, short of setting the age inventory 
setting for all inventory.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Wednesday, November 1, 2017 7:35 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Prevent custom hardware inventory class from keeping history?

I am having no luck finding a way to do this. Does anyone know how to prevent 
custom hardware inventory classes from keeping history?

Thanks!

Daniel Ratliff


The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information 
in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.



The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information 
in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística.

Re: [External] [mssms] RE: Prevent custom hardware inventory class from keeping history?

[Sherry Kissinger]

I can't say what company I work for but...
https://mnscug.org/blogs/sherry-kissinger/357-configmgr-2012-truncate-history-tables
we run that every night on our sql servers that have a CM database.

On Wed, Nov 1, 2017 at 9:06 AM, Miller, Todd <todd-mil...@uiowa.edu> wrote:

> I think I remember hearing about an site – was it Welles Fargo?-- that was
> running a SQL maintenance task to truncate ALL their history tables in
> Configmgr.  I am not sure if it has to be an all or nothing thing.  It
> might be possible to just truncate the history table for that one thing in
> SQL as a maintenance task.
>
>
>
>
>
> (nice disclaimer notification, by the way.   These things are getting out
> of hand, eh?)
>
>
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com] *On Behalf Of *Daniel Ratliff
> *Sent:* Wednesday, November 01, 2017 8:38 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* [External] [mssms] RE: Prevent custom hardware inventory class
> from keeping history?
>
>
>
> Thanks Garth! We added some custom inventory a few weeks ago to track some
> specific event logs, and the HINV history tables are upwards of 300GB. Way
> larger than we were expecting. Fun times.
>
>
>
> *Daniel Ratliff*
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com <listsad...@lists.myitforum.com>] *On Behalf Of *Garth Jones
> *Sent:* Wednesday, November 1, 2017 8:58 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* [mssms] RE: Prevent custom hardware inventory class from
> keeping history?
>
>
>
> Hi Daniel, I know of no way to do this, short of setting the age inventory
> setting for all inventory.
>
>
>
>
>
>
>
>
>
> Garth Jones
>
> Chief Architect
>
> *See us at Microsoft Ignite in booth #1246!
> <https://www.enhansoft.com/conferences/microsoft-ignite-2017>*
>
>
>
> *From:* listsad...@lists.myitforum.com [mailto:listsadmin@lists.
> myitforum.com <listsad...@lists.myitforum.com>] *On Behalf Of *Daniel
> Ratliff
> *Sent:* Wednesday, November 1, 2017 7:35 AM
> *To:* mssms@lists.myitforum.com
> *Subject:* [mssms] Prevent custom hardware inventory class from keeping
> history?
>
>
>
> I am having no luck finding a way to do this. Does anyone know how to
> prevent custom hardware inventory classes from keeping history?
>
>
>
> Thanks!
>
>
>
> *Daniel Ratliff*
>
>
>
>
> The information transmitted is intended only for the person or entity to
> which it is addressed
> and may contain CONFIDENTIAL material. If you receive this
> material/information in error,
> please contact the sender and delete or destroy the material/information.
>
> Humana Inc. and its subsidiaries comply with applicable Federal civil
> rights laws and
> do not discriminate on the basis of race, color, national origin, age,
> disability or
> sex. Humana Inc. and its subsidiaries do not exclude people or treat them
> differently
> because of race, color, national origin, age, disability or sex.
>
> English: ATTENTION: If you do not speak English, language assistance
> services, free
> of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).
>
> Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición
> servicios
> gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).
>
> 繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
> 服務。請致電 1‐877‐320‐1235 (TTY: 711)。
>
> Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen
> sèvis èd
> pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).
>
> Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z
> bezpłatnej
> pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).
>
> 한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
> 이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.
>
>
>
> [image:
> http://t.sidekickopen65.com/e1t/o/5/f18dQhb0S7ks8dDMPbW2n0x6l2B9gXrN7sKj6v4dY-KW8rldKY5v0sYvVd7jV42zlZNzW997dy61k1H6H0?si=4807360900104192=8cc42a66-939f-4943-b1be-3655523a8e37]
>
>
>
>
> The information transmitted is intended only for the person or entity to
> which it is addressed
> and may contain CONFIDENTIAL material. If you receive this
> material/information in error,
> please contact the sender and delete or destroy the material/information.
>
> Humana Inc. and its subsidiaries comply with applicable Federal civil
> rights laws and
> do not discriminate on the basis of race, color, national origin, age,
> disability or
> sex. Humana Inc. and its subsidiaries do not exclude people or treat them
> differently
> because of race, c

RE: [External] [mssms] RE: Prevent custom hardware inventory class from keeping history?

[Miller, Todd]

I think I remember hearing about an site – was it Welles Fargo?-- that was 
running a SQL maintenance task to truncate ALL their history tables in 
Configmgr.  I am not sure if it has to be an all or nothing thing.  It might be 
possible to just truncate the history table for that one thing in SQL as a 
maintenance task.


(nice disclaimer notification, by the way.   These things are getting out of 
hand, eh?)


From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Wednesday, November 01, 2017 8:38 AM
To: mssms@lists.myitforum.com
Subject: [External] [mssms] RE: Prevent custom hardware inventory class from 
keeping history?

Thanks Garth! We added some custom inventory a few weeks ago to track some 
specific event logs, and the HINV history tables are upwards of 300GB. Way 
larger than we were expecting. Fun times.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Garth Jones
Sent: Wednesday, November 1, 2017 8:58 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] RE: Prevent custom hardware inventory class from keeping 
history?

Hi Daniel, I know of no way to do this, short of setting the age inventory 
setting for all inventory.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Wednesday, November 1, 2017 7:35 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Prevent custom hardware inventory class from keeping history?

I am having no luck finding a way to do this. Does anyone know how to prevent 
custom hardware inventory classes from keeping history?

Thanks!

Daniel Ratliff


The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information 
in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.




The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information 
in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.




Notice: This UI Health Care e-mail (including attachments) is covered by the 
Electronic Communications Privacy Act, 18 U.S.C. 2510-2521 and is intended only 
for the use of the individual or entity to which it is addressed

[mssms] RE: Prevent custom hardware inventory class from keeping history?

[Daniel Ratliff]

Thanks Garth! We added some custom inventory a few weeks ago to track some 
specific event logs, and the HINV history tables are upwards of 300GB. Way 
larger than we were expecting. Fun times.

Daniel Ratliff

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Garth Jones
Sent: Wednesday, November 1, 2017 8:58 AM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: Prevent custom hardware inventory class from keeping 
history?

Hi Daniel, I know of no way to do this, short of setting the age inventory 
setting for all inventory.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!<https://www.enhansoft.com/conferences/microsoft-ignite-2017>

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Daniel Ratliff
Sent: Wednesday, November 1, 2017 7:35 AM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] Prevent custom hardware inventory class from keeping history?

I am having no luck finding a way to do this. Does anyone know how to prevent 
custom hardware inventory classes from keeping history?

Thanks!

Daniel Ratliff


The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information 
in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.




The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material.  If you receive this 
material/information in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.

[mssms] RE: Prevent custom hardware inventory class from keeping history?

[Garth Jones]

Hi Daniel, I know of no way to do this, short of setting the age inventory 
setting for all inventory.




Garth Jones
Chief Architect
See us at Microsoft Ignite in booth 
#1246!

From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Wednesday, November 1, 2017 7:35 AM
To: mssms@lists.myitforum.com
Subject: [mssms] Prevent custom hardware inventory class from keeping history?

I am having no luck finding a way to do this. Does anyone know how to prevent 
custom hardware inventory classes from keeping history?

Thanks!

Daniel Ratliff


The information transmitted is intended only for the person or entity to which 
it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information 
in error,
please contact the sender and delete or destroy the material/information.

Humana Inc. and its subsidiaries comply with applicable Federal civil rights 
laws and
do not discriminate on the basis of race, color, national origin, age, 
disability or
sex. Humana Inc. and its subsidiaries do not exclude people or treat them 
differently
because of race, color, national origin, age, disability or sex.

English: ATTENTION: If you do not speak English, language assistance services, 
free
of charge, are available to you. Call 1‐877‐320‐1235 (TTY: 711).

Español (Spanish): ATENCIÓN: Si habla español, tiene a su disposición servicios
gratuitos de asistencia lingüística. Llame al 1‐877‐320‐1235 (TTY: 711).

繁體中文(Chinese)：注意：如果您使用繁體中文，您可以免費獲得語言援助
服務。請致電 1‐877‐320‐1235 (TTY: 711)。

Kreyòl Ayisyen (Haitian Creole): ATANSION: Si w pale Kreyòl Ayisyen, gen sèvis 
èd
pou lang ki disponib gratis pou ou. Rele 1‐877‐320‐1235 (TTY: 711).

Polski (Polish): UWAGA: Jeżeli mówisz po polsku, możesz skorzystać z bezpłatnej
pomocy językowej. Zadzwoń pod numer 1‐877‐320‐1235 (TTY: 711).

한국어 (Korean): 주의: 한국어를 사용하시는 경우, 언어 지원 서비스를 무료로
이용하실 수 있습니다. 1‐877‐320‐1235 (TTY: 711)번으로 전화해 주십시오.