What is the differnece in the table names of GS and HS?

Question

Something i've found:

Views displaying current inventory data are named v_GS_<group name>.
Views displaying inventory history data are named v_HS_<group name>.

Although that makes sense, I'd like to understand deeper.

1. Are all tables mirrored between the two?
2. At what point does GS (current) move to HS (Historical)?

When I write my SQL, should I be including both?

Answer 1

1. No they are not mirrored pre se. Only history data will show in the history views.
2. They move from current to history when details are changed/removed/added. aka if you currently have 16gb of ram on Oct 1 2020 this will be the current value until it changes. On Jan 20 2021 you go to 32 GB of RAM, it will become the new current and the old value will be add to history and will stay for ~90 days.

Answer 2

When I write my SQL, should I be including both

It depend on what you are trying to do BUt IMO 95% of the time NO, there is no use for history data.

Answer 3

@My9to5
Thank you for posting in Microsoft Q&A forum.
Like Garth said, in most cases, we only use the current inventory data with the name v_GS_<group name>.
We seldom use the inventory history date, for example, if we want to check if there any change for client computer disk size, we may include both v_GS_DISK and v_HS_DISK like below:

SELECT DISTINCT  
  RV.Netbios_Name0 as 'Pc Name',  
  RV.User_Domain0 as 'User Name',  
  GD.DeviceID0 as 'Device ID',  
  GD.Size0 as 'Current HD Size',  
  HD.Size0 as 'Historic  HD Size'  
FROM  
  dbo.v_R_System_Valid RV  
  INNER JOIN v_GS_DISK GD ON RV.ResourceID = GD.ResourceID  
  INNER JOIN v_HS_DISK HD ON RV.ResourceID = HD.ResourceID  
WHERE  
  GD.Size0 <> HD.Size0 and GD.DeviceID0 = HD.DeviceID0   

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.