Azure REST API Powershell ADO Rest API System.AssignedTo does not show a value

DBTech 1 Reputation point
2022-04-28T02:19:52.9+00:00

Question: Is there a way to get System.AssignedTo to display a value or any field containing an user? Unable to get any identity show.

Results:
197106-image.png

Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,457 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Limitless Technology 39,511 Reputation points
    2022-05-05T07:10:58.567+00:00

    Hi DBTech,

    To answer your query, In Management Studio, open the Object Explorer.

    Go to your database
    There's a subnode Views
    Find your view
    Choose Script view as > Create To > New query window

    In Management Studio, open the Object Explorer.

    Go to your database
    There's a subnode Views
    Find your view
    Choose Script view as > Create To > New query window

    If you want to retrieve the SQL statement that defines the view from T-SQL code, use this:

    SELECT
    m.definition
    FROM sys.views v
    INNER JOIN sys.sql_modules m ON m.object_id = v.object_id
    WHERE name = 'Example_1'


    If the answer is helpful kindly click "Accept Answer" and upvote it. Thanks.

    0 comments No comments