Microsoft Dynamics AX (Archived)

Check if Project exists from PowerShell

(0) Share

Report

Posted on by Rudi Hansen

4,073

As a part of my deployment Power-Shell script, I need to check if an Development Project exists in AX.

Does anyone know how to do that?

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Sohaib Cheema 48,938 User Group Leader on at

Like (0)

Report

RE: Check if Project exists from PowerShell

A way i can imagine is to call .net code from PowerShell and .Net code should be responsible to read AX using AIF web services.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 236,519 Most Valuable Professional on at

Like (0)

Report

RE: Check if Project exists from PowerShell

You can also use Business Connector from Powershell. This is a solution if you can't make custom web services.

Of course, Business Connector doesn't exist in newer versions of AX, but no solution will be upgradable and therefore it doesn't matter.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: Check if Project exists from PowerShell

If you have database access to the model database you could also use an SQL script such as:

SELECT ISNULL((select top 1 1

FROM [YOUR_MODEL_DATABASE].[dbo].[ModelElement]

where ElementType = 37 AND Name = 'YOUR_PROJECT_NAME'),0)

To use this from powershell you can use the Invoke-SqlCmd scriptlet

Was this reply helpful? Yes No
Suggested answer

Daniel Weichsel on at

Like (0)

Report
RE: Check if Project exists from PowerShell

Assuming you have the AX2012 model management cmdlets at your disposal:

@('USR Model', 'VAR Model') | % { Get-AxModel -Model $_ -Details | Select -ExpandProperty Elements } | ? { $_.ElementType -eq 'SharedProject' -and $_.Name -eq 'MyProjectName' }

This starts with a list of models you want to search within, gets the model content for each, then filters that down to only shared projects with a matching name. Adjust as needed.

Was this reply helpful? Yes No
Sohaib Cheema 48,938 User Group Leader on at

Like (0)

Report

RE: Check if Project exists from PowerShell

@Daniel Weichsel,

This is great command. I wonder how this will behave with search of private project. I assume we need to pass Creator_PrivateProjectName instead of just PrivateProjectName, whereas for SharedProjects this works great.

We cannot trust Like operator in that case for powershell by saying

-and $._Name -Like '*NameOfMyPrivateProject'

Was this reply helpful? Yes No
Daniel Weichsel on at

Like (0)

Report

RE: Check if Project exists from PowerShell

@Sohaib Cheema, you've got it. AxUserId_PrivateProjectName. If you need to avoid wildcards, you'll have to know the AX user ID ahead of time, or you might use the Get-AxUser cmdlet to help get the AX user ID matching a Windows identity. Get-AxUser does establish a Business Connector session behind the scenes though, so the target environment would have to be running.

Was this reply helpful? Yes No
Rudi Hansen 4,073 on at

Like (0)

Report

RE: Check if Project exists from PowerShell

[quote user="Daniel Weichsel"]

@('USR Model', 'VAR Model') | % { Get-AxModel -Model $_ -Details | Select -ExpandProperty Elements } | ? { $_.ElementType -eq 'SharedProject' -and $_.Name -eq 'MyProjectName' }

[/quote]

This looks like it does what i need thanks for the tip.

Was this reply helpful? Yes No