Digging SCCM SQL Database : SCCM Database Tables and Columns

I have been always struggling to get desired data from SCCM and it's a really hard job. At least for me J

Following query resolved my all problem of searching information

SELECT * FROM INFORMATION_SCHEMA.Columns 

This gives you all SCCM sql tables information with their columns detail.



Now you know what is where ….

Cheers……


Comments

Popular posts from this blog

Windows Deployment Service ( WDS ) and Errors and Solutions

DHCP, WDS, PXE Boot and Common Issues

SCCM Questions & Answers