how to edit MDT database?

lupinlicious 136 Reputation points
2022-03-06T16:05:24.573+00:00

Hello,

How do I edit the SQL database so it populates another another column under the MDT > Database > Computer

I would like to add "Computername"

180464-image.png

I have added the column in the database like this:

180432-image.png

..and from another page, https://syscenramblings.wordpress.com/2016/01/15/mdt-database-and-custom-values/
they describe that I need to query the database like this:

EXECUTE sp_refreshview ‘[dbo].[ComputerSettings]’  
EXECUTE sp_refreshview ‘[dbo].[LocationSettings]’  
EXECUTE sp_refreshview ‘[dbo].[MakeModelSettings]’  
EXECUTE sp_refreshview ‘[dbo].[RoleSettings]’  

I guess that sp_refreshview won't do in my case, how do I query this?

Another question:

Where do I find all my data if I'd like to manually delete an entry in the database?

Thaaaank you!

Microsoft Deployment Toolkit
Microsoft Deployment Toolkit
A collection of Microsoft tools and documentation for automating desktop and server deployment. Previously known as Microsoft Solution Accelerator for Business Desktop Deployment (BDD).
837 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Simon Ren-MSFT 30,681 Reputation points Microsoft Vendor
    2022-03-07T09:48:00.57+00:00

    Hi,

    Thanks for posting in Microsoft MECM Q&A forum.

    ==>Where do I find all my data if I'd like to manually delete an entry in the database?
    It's really not suggest to munaully delete/add any entry in the database, because it is a really high risk opration and may destroy the whole database

    ==>I guess that sp_refreshview won't do in my case, how do I query this?
    I will do more research about the query, if there is any update, I will keep you on posted.

    Thanks for your kindly understanding. Have a good day!

    Best regards,
    Simon


    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.