Posts

Showing posts from February, 2016

SCUP 2011 : Failed to Publish Software Update

Image
Hey Guys, I just recently faced an issue when I was publishing Adobe flash player update using SCUP 2011. Following was error in SCUP.log Download file: https://fpdownload.macromedia.com/pub/flashplayer/pdc/20.0.0.286/install_flash_player_20_active_x.msi failed with message "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." PublishItem: Download Content: Failed to download file 'https://fpdownload.macromedia.com/pub/flashplayer/pdc/20.0.0.286/install_flash_player_20_active_x.msi'. As error states that there is a connection and download issue…. Checked download settings….. was ok Checked Firewall settings…… was ok Checked Proxy settings…… was ok Copied update’s download URL and tried downloading manually… omg that is also working …. Now what is the issue…. Went to edit the update and removed…….S   J Yeah!!.....changed download url from https://fpdownload.macr...

Digging SCCM SQL Database : SCCM Database Tables and Columns

Image
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……

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 rela...