1E Shopping Database : Delete machine history from database

By San -
delete from tb_Machine where MachineName='XXXX'

Comments

Post a Comment

Popular posts from this blog

Power BI : Microsoft Office Telemetry Dashboard

By San -
Image
Microsoft Office's Telemetry Dashboard is an essential add-on for giving your environment an Office Health Index - where you have it, licensing, upgrade, tracking issues, AppCompat etc. The insight telemetry provide is priceless and yet free. Here the data sources are both the telemetry database, telemetry excel dashboard, and the SCCM database. Installation + Configuration of Telemetry : https://technet.microsoft.com/en-us/library/jj863580.aspx?f=255&MSPPError=-2147217396 Configure and deploy the dashboard : https://technet.microsoft.com/en-us/library/jj853312.aspx?f=255&MSPPError=-2147217396 want the  pbix  file ?  share this post on  twitter  or  fb  and comment with the link of ur shared post & your email in the comment window below.
Read more

SCCM SQL Query : SQL Query for Locations and Boundaries

By San -
select sys1.Name, sys1.DefaultSiteCode, (select SUBSTRING(sys2.ServerNALPath, CHARINDEX('\\', sys2.ServerNALPath) + 2, CHARINDEX('"]', sys2.ServerNALPath) - CHARINDEX('\\', sys2.ServerNALPath) - 3 ) + CASE sys2.Flags WHEN '1' Then ' (Slow)' WHEN '0' THEN '' END + '; ' as 'data()' from vSMS_BoundaryGroupSiteSystems as sys2 where sys1.GroupID=sys2.GroupID for XML path('')) as 'Site System', (select sys4.Value + '; ' as 'data()' from vSMS_BoundaryGroupMembers as sys3 left join vSMS_Boundary as sys4 on sys3.BoundaryID=sys4.BoundaryID where sys1.GroupID=sys3.GroupID for XML path('')) as 'Boundary', sys1.ModifiedOn, sys1.ModifiedBy from vSMS_BoundaryGroup as sys1
Read more