SCCM SQL Views Types

-
Hi Folks,

This time We'll talk about SCCM SQL Views.


What is SCCM SQL Views?

SCCM SQL Views is part of SCCM SQL Database and contain information about all SCCM components like Resources, Collections, Updates, All Packages ...everything......

Hence provide option to fetch custom data or create custom reports.

Following are types of  SCCM SQL Views and contains information in categories.....


V_*                 : default view
V_R_  *          : It will fill the values with Discovery data
V_RA_  *        :  It will, fill the values Once Discovered and Assigned
V_GS_*         :  HINV/SINV/Software Granular data- Present/Current inv data
V_HS_*          : Historical data after 90 days - Task maintenance data HINV/SINV/Software
V_AI_*          : Asset Intelligence related data
V_CI_*           : Configuration Item (5 types)

V_CH_*         :  Client Health validation related data

Now you will have idea that which view type information would be containing what info and can include them for custom reports
Surely, We'll go through how to create custom reports in next post...

 Cheers…..

Comments

Post a Comment

Popular posts from this blog

Windows Deployment Service ( WDS ) and Errors and Solutions

-
Image
Hi Guys... This post is all about Windows Deployment service WDS and its Errors and solutions. WDS is used to deploy Operating System Images and also is SCCM OSD Component. Many times we all have faced WDS issues and errors. Following are Some of Issues and their solutions Error 10048 Description: The Windows Deployment Services Server service terminated with service-specific error 10048 This issue occurs if the following conditions are true: ·          The DHCP server and the WDS server are installed on the same computer. ·          The  Do not listen on port 67  option is  NOT  enabled in the DHCP tab. Cause When the DHCP server and the WDS server are installed on the same computer, the WDS Service tries to use the port 67. However, the DHCP server already uses this port. Solution: Method 1 At the command prompt, type the following command, and th...
Read more

DHCP, WDS, PXE Boot and Common Issues

-
Image
Hi Guys, Again i am back with very common information about DHCP,WDS & PXE and issues troubleshooting and their solutions. DHCP, WDS, and PXE are the main and needed components which plays very important role in SCCM OSD. They function and provide a very cool and automatize the OS installations (Network based). So why is the Need? DHCP : DHCP offers automatic ip address assigning functionality to machines at both booting state and online state. DHCP Scope options are one main key component. WDS : WDS offers the PXE functionality (Not SCCM) for network based OS installation (boots machine in to windows installation mode from network) So when we install the SCCM PXE service Point on WDS Server, It just overrides the settings of WDS PXE. Now Common PXE Boot Issues: ·         PXE-E53: No boot filename received   ·         PXE-T01: File not found ·    ...
Read more

SCCM Questions & Answers

-
Hi guys , Cool  Q's & A's for SCCM Interviews. SCCM Questions & Answers Q. What Is SCCM? System Center Configuration Manager   (CM12   or   CM07   or   ConfigMgr   or   Configuration Manager), formerly   Systems Management Server   (SMS), is a   systems management   software product by   Microsoft   for managing large groups of   Windows -based computer systems. Configuration Manager provides remote control, patch management, software distribution, operating system deployment, network access protection, and hardware and software inventory . Q. what are the versions of SCCM?                                                                                           ...
Read more