Yeah I had thought to look for v_HS_ but I don’t actually see anything as 
interesting as it’s doing in that view.

Example –

It has a section “modified items since last inventory collection”

New items since last inventory collection

Removed items since last inventory collection.



From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On 
Behalf Of Daniel Ratliff
Sent: Thursday, August 24, 2017 4:24 PM
To: mssms@lists.myitforum.com
Subject: [mssms] RE: SCCM View or Report Similar to Resource Explorer for 
add/remove?

Everything, and I mean everything, inventory wise is in the database. That is 
where Resource Explorer reads from!

What you want is v_gs_<viewname> for current hardware inventory and 
v_hs_<viewname> for historical data.

For that specific view, look for v_hs_add_remove_programs.

Daniel Ratliff

From: listsad...@lists.myitforum.com<mailto:listsad...@lists.myitforum.com> 
[mailto:listsad...@lists.myitforum.com] On Behalf Of Burke, John
Sent: Thursday, August 24, 2017 2:59 PM
To: mssms@lists.myitforum.com<mailto:mssms@lists.myitforum.com>
Subject: [mssms] SCCM View or Report Similar to Resource Explorer for 
add/remove?

Hi,

I’m wondering if there are views that give me a nice break down of what changed 
since last inventory the way resource explorer does. This is for CB

[cid:image001.png@01D31CF7.871EF850]


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)번으로 전화해 주십시오.


Reply via email to