diff options
| author | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2025-01-23 03:04:26 +0200 |
|---|---|---|
| committer | Roy Ben Shabat <Roy.mail.net@gmail.com> | 2025-01-23 03:04:26 +0200 |
| commit | 6949f8b47f6b380e5bf43f42f78b0c126b492850 (patch) | |
| tree | 34953141ed4ad9c51cf45489a3f9e3cb5b9279d0 /Software/Visual_Studio/Notes | |
| parent | f0dc1fb8ce29ee676a9a6ca9414756a852e31e26 (diff) | |
| download | Tango-6949f8b47f6b380e5bf43f42f78b0c126b492850.tar.gz Tango-6949f8b47f6b380e5bf43f42f78b0c126b492850.zip | |
X1 Future
Diffstat (limited to 'Software/Visual_Studio/Notes')
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/DB/View All Machines Versions.sql | 6 | ||||
| -rw-r--r-- | Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj | 3 |
2 files changed, 8 insertions, 1 deletions
diff --git a/Software/Visual_Studio/Notes/Tango.Notes/DB/View All Machines Versions.sql b/Software/Visual_Studio/Notes/Tango.Notes/DB/View All Machines Versions.sql new file mode 100644 index 000000000..b5108b62e --- /dev/null +++ b/Software/Visual_Studio/Notes/Tango.Notes/DB/View All Machines Versions.sql @@ -0,0 +1,6 @@ +SELECT MACHINE_VERSIONS.NAME MACHINE_TYPE, SERIAL_NUMBER, MACHINES.NAME NAME, ORGANIZATIONS.NAME ORGANIZATION, SITES.NAME SITE, UPDATED_ON, APPLICATION_VERSION, FIRMWARE_VERSION, VERSION_TAG FROM (SELECT MACHINE_GUID, MAX(LAST_UPDATED) UPDATED_ON FROM TANGO_UPDATES GROUP BY MACHINE_GUID) LAST_UPDATES +INNER JOIN MACHINES ON MACHINES.GUID = LAST_UPDATES.MACHINE_GUID +INNER JOIN TANGO_UPDATES ON TANGO_UPDATES.LAST_UPDATED = LAST_UPDATES.UPDATED_ON +INNER JOIN ORGANIZATIONS ON ORGANIZATIONS.GUID = MACHINES.ORGANIZATION_GUID +INNER JOIN MACHINE_VERSIONS ON MACHINE_VERSIONS.GUID = MACHINES.MACHINE_VERSION_GUID +LEFT JOIN SITES ON SITES.GUID = MACHINES.SITE_GUID ORDER BY APPLICATION_VERSION DESC
\ No newline at end of file diff --git a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj index 7c0014747..0114b617c 100644 --- a/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj +++ b/Software/Visual_Studio/Notes/Tango.Notes/Tango.Notes.csproj @@ -50,6 +50,7 @@ <Content Include="Azure\Test User Credentials.txt" /> <Content Include="Azure\SQL Database.txt" /> <None Include="DB\Fix Domain User Script.bat" /> + <Content Include="DB\View All Machines Versions.sql" /> <Content Include="DB\Repair Suspect Mode.txt" /> <Content Include="DB\DB Schema Change Log.txt" /> <Content Include="DB\Drop All Tables.sql" /> @@ -73,7 +74,7 @@ <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> <ProjectExtensions> <VisualStudio> - <UserProperties BuildVersion_StartDate="2000/1/1" BuildVersion_UseGlobalSettings="False" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" /> + <UserProperties BuildVersion_AssemblyInfoFilename="Properties\AssemblyInfo.cs" BuildVersion_UpdateAssemblyVersion="True" BuildVersion_BuildVersioningStyle="None.None.Increment.TimeStamp" BuildVersion_UseGlobalSettings="False" BuildVersion_StartDate="2000/1/1" /> </VisualStudio> </ProjectExtensions> </Project>
\ No newline at end of file |