mirror of
https://github.com/krugersu/YY.EventLogExportAssistant.git
synced 2026-06-20 01:16:51 +02:00
195 lines
9.5 KiB
XML
195 lines
9.5 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<root>
|
|
<!--
|
|
Microsoft ResX Schema
|
|
|
|
Version 2.0
|
|
|
|
The primary goals of this format is to allow a simple XML format
|
|
that is mostly human readable. The generation and parsing of the
|
|
various data types are done through the TypeConverter classes
|
|
associated with the data types.
|
|
|
|
Example:
|
|
|
|
... ado.net/XML headers & schema ...
|
|
<resheader name="resmimetype">text/microsoft-resx</resheader>
|
|
<resheader name="version">2.0</resheader>
|
|
<resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>
|
|
<resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>
|
|
<data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>
|
|
<data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>
|
|
<data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">
|
|
<value>[base64 mime encoded serialized .NET Framework object]</value>
|
|
</data>
|
|
<data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">
|
|
<value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>
|
|
<comment>This is a comment</comment>
|
|
</data>
|
|
|
|
There are any number of "resheader" rows that contain simple
|
|
name/value pairs.
|
|
|
|
Each data row contains a name, and value. The row also contains a
|
|
type or mimetype. Type corresponds to a .NET class that support
|
|
text/value conversion through the TypeConverter architecture.
|
|
Classes that don't support this are serialized and stored with the
|
|
mimetype set.
|
|
|
|
The mimetype is used for serialized objects, and tells the
|
|
ResXResourceReader how to depersist the object. This is currently not
|
|
extensible. For a given mimetype the value must be set accordingly:
|
|
|
|
Note - application/x-microsoft.net.object.binary.base64 is the format
|
|
that the ResXResourceWriter will generate, however the reader can
|
|
read any of the formats listed below.
|
|
|
|
mimetype: application/x-microsoft.net.object.binary.base64
|
|
value : The object must be serialized with
|
|
: System.Runtime.Serialization.Formatters.Binary.BinaryFormatter
|
|
: and then encoded with base64 encoding.
|
|
|
|
mimetype: application/x-microsoft.net.object.soap.base64
|
|
value : The object must be serialized with
|
|
: System.Runtime.Serialization.Formatters.Soap.SoapFormatter
|
|
: and then encoded with base64 encoding.
|
|
|
|
mimetype: application/x-microsoft.net.object.bytearray.base64
|
|
value : The object must be serialized into a byte array
|
|
: using a System.ComponentModel.TypeConverter
|
|
: and then encoded with base64 encoding.
|
|
-->
|
|
<xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
|
|
<xsd:import namespace="http://www.w3.org/XML/1998/namespace" />
|
|
<xsd:element name="root" msdata:IsDataSet="true">
|
|
<xsd:complexType>
|
|
<xsd:choice maxOccurs="unbounded">
|
|
<xsd:element name="metadata">
|
|
<xsd:complexType>
|
|
<xsd:sequence>
|
|
<xsd:element name="value" type="xsd:string" minOccurs="0" />
|
|
</xsd:sequence>
|
|
<xsd:attribute name="name" use="required" type="xsd:string" />
|
|
<xsd:attribute name="type" type="xsd:string" />
|
|
<xsd:attribute name="mimetype" type="xsd:string" />
|
|
<xsd:attribute ref="xml:space" />
|
|
</xsd:complexType>
|
|
</xsd:element>
|
|
<xsd:element name="assembly">
|
|
<xsd:complexType>
|
|
<xsd:attribute name="alias" type="xsd:string" />
|
|
<xsd:attribute name="name" type="xsd:string" />
|
|
</xsd:complexType>
|
|
</xsd:element>
|
|
<xsd:element name="data">
|
|
<xsd:complexType>
|
|
<xsd:sequence>
|
|
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
|
|
<xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />
|
|
</xsd:sequence>
|
|
<xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />
|
|
<xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />
|
|
<xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />
|
|
<xsd:attribute ref="xml:space" />
|
|
</xsd:complexType>
|
|
</xsd:element>
|
|
<xsd:element name="resheader">
|
|
<xsd:complexType>
|
|
<xsd:sequence>
|
|
<xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />
|
|
</xsd:sequence>
|
|
<xsd:attribute name="name" type="xsd:string" use="required" />
|
|
</xsd:complexType>
|
|
</xsd:element>
|
|
</xsd:choice>
|
|
</xsd:complexType>
|
|
</xsd:element>
|
|
</xsd:schema>
|
|
<resheader name="resmimetype">
|
|
<value>text/microsoft-resx</value>
|
|
</resheader>
|
|
<resheader name="version">
|
|
<value>2.0</value>
|
|
</resheader>
|
|
<resheader name="reader">
|
|
<value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
|
|
</resheader>
|
|
<resheader name="writer">
|
|
<value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>
|
|
</resheader>
|
|
<data name="Query_CreateView_vw_EventLog" xml:space="preserve">
|
|
<value>IF NOT EXISTS (SELECT *
|
|
FROM sys. objects
|
|
WHERE object_id = OBJECT_ID('dbo.vw_EventLog') AND type = 'V')
|
|
BEGIN
|
|
EXECUTE(
|
|
'CREATE VIEW [dbo].[vw_EventLog]
|
|
AS
|
|
SELECT
|
|
[RD].[InformationSystemId] AS [InformationSystemId],
|
|
[IS].[Name] AS [InformationSystemName],
|
|
[RD].[Period],
|
|
[RD].[Id] AS [RowId],
|
|
[RD].[SeverityId] AS [SeverityId],
|
|
[SV].[Name] AS [SeverityName],
|
|
[RD].[ConnectId] AS [Connection],
|
|
[RD].[Session],
|
|
[RD].[TransactionStatusId],
|
|
[RD].[TransactionDate],
|
|
[RD].[TransactionId],
|
|
[RD].[UserId] AS [UserId],
|
|
[USR].[Name] AS [UserName],
|
|
[USR].[Uuid] AS [UserUUID],
|
|
[RD].[ComputerId] AS [ComputerId],
|
|
[CMP].[Name] AS [ComputerName],
|
|
[RD].[Data],
|
|
[RD].[DataUUID],
|
|
[RD].[DataPresentation],
|
|
[RD].[Comment],
|
|
[RD].[ApplicationId] AS [ApplicationId],
|
|
[APPS].[Name] AS [ApplicationName],
|
|
[RD].[EventId] AS [EventId],
|
|
[EVNT].[Name] AS [EventName],
|
|
[RD].[MetadataId] AS [MetadataId],
|
|
[META].[Name] AS [MetadataName],
|
|
[META].[Uuid] AS [MetadataUUID],
|
|
[RD].[WorkServerId] AS [WorkServerId],
|
|
[WSRV].[Name] AS [WorkServerName],
|
|
[RD].[PrimaryPortId] AS [PrimaryPortId],
|
|
[PPRT].[Name] AS [PrimaryPortName],
|
|
[RD].[SecondaryPortId] AS [SecondaryPortId],
|
|
[SPRT].[Name] AS [SecondaryPortName]
|
|
FROM [dbo].[RowsData] AS [RD]
|
|
LEFT JOIN [dbo].[InformationSystems] AS [IS]
|
|
ON [RD].[InformationSystemId] = [IS].[Id]
|
|
LEFT JOIN [dbo].[Severities] AS [SV]
|
|
ON [RD].[InformationSystemId] = [SV].[InformationSystemId]
|
|
AND [RD].[SeverityId] = [SV].[Id]
|
|
LEFT JOIN [dbo].[Users] AS [USR]
|
|
ON [RD].[InformationSystemId] = [USR].[InformationSystemId]
|
|
AND [RD].[UserId] = [USR].[Id]
|
|
LEFT JOIN [dbo].[Computers] AS [CMP]
|
|
ON [RD].[InformationSystemId] = [CMP].[InformationSystemId]
|
|
AND [RD].[ComputerId] = [CMP].[Id]
|
|
LEFT JOIN [dbo].[Applications] AS [APPS]
|
|
ON [RD].[InformationSystemId] = [APPS].[InformationSystemId]
|
|
AND [RD].[ApplicationId] = [APPS].[Id]
|
|
LEFT JOIN [dbo].[Events] AS [EVNT]
|
|
ON [RD].[InformationSystemId] = [EVNT].[InformationSystemId]
|
|
AND [RD].[EventId] = [EVNT].[Id]
|
|
LEFT JOIN [dbo].[Metadata] AS [META]
|
|
ON [RD].[InformationSystemId] = [META].[InformationSystemId]
|
|
AND [RD].[MetadataId] = [META].[Id]
|
|
LEFT JOIN [dbo].[WorkServers] AS [WSRV]
|
|
ON [RD].[InformationSystemId] = [WSRV].[InformationSystemId]
|
|
AND [RD].[WorkServerId] = [WSRV].[Id]
|
|
LEFT JOIN [dbo].[PrimaryPorts] AS [PPRT]
|
|
ON [RD].[InformationSystemId] = [PPRT].[InformationSystemId]
|
|
AND [RD].[PrimaryPortId] = [PPRT].[Id]
|
|
LEFT JOIN [dbo].[SecondaryPorts] AS [SPRT]
|
|
ON [RD].[InformationSystemId] = [SPRT].[InformationSystemId]
|
|
AND [RD].[SecondaryPortId] = [SPRT].[Id]')
|
|
END</value>
|
|
<comment>Запрос создания представления "vw_EventLog"</comment>
|
|
</data>
|
|
</root> |