SCCM discovery custom attributes.

One thing I'm often asked about is how to type in specific data into SMS/SCCM, add an asset number to a system for example, since SMS/SCCM has no such feature most of us just store the data on the clients registry and pull it back by modifying the SMS_DEF.MOF.

Custom discover attributes are how ever an option that now allows us to use AD as a place to type in simple asset information.

But there are other data we might be interested to retrieve like when did a computer account change it's password in AD, this can be valuable when troubleshooting client and advertisement problems.

 Adding the custom attributes that you want to collect is simple, just press the asterisk and type in the name of the attribute:

The LDAP attribute is not stored in a normal date format so it has to be converted in your report:

SELECT     Netbios_Name0 AS [System Name], Description0 AS Description, DATEADD(minute, (CONVERT(bigint, pwdLastSet0) - 47966688000000000) / 600000000.0, '17530101') AS [Password Last Changed] FROM v_R_System

 (Conversion made by Michael Valentine Jones found in this tread: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108759)