1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177
|
<%@ Page Language="VB" %>
<%@ Register TagPrefix="wmx" Namespace="Microsoft.Matrix.Framework.Web.UI" Assembly="Microsoft.Matrix.Framework, Version=0.6.0.0, Culture=neutral, PublicKeyToken=6f763c9966660626" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="System.Web.Mail" %>
<%@ import Namespace="System.IO" %>
<%@ import Namespace="System.DirectoryServices" %>
<%@ import Namespace="System.Configuration" %>
<%@ import Namespace="System.Net" %>
<%@ import Namespace="System" %>
<%@ import Namespace="System.Net.DNS" %>
<%@ import Namespace="System.ComponentModel" %>
<%@ import Namespace="System.Management" %>
<%@ import Namespace="System.Runtime.InteropServices" %>
<%@ import Namespace="System" %>
<%@ import Namespace="ActiveDs" %>
<%@ import Namespace="System.Text" %>
<%@ import Namespace="System.Net.NetworkInformation" %>
<%@ import Namespace="System.Net.Sockets" %>
<script runat="server">
' Insert page code here
'
Sub Page_Load()
Dim Ldap As DirectoryEntry = New DirectoryEntry("LDAP://tamac.local", "toto", "toto")
Dim searcher As DirectorySearcher = New DirectorySearcher(Ldap)
searcher.Filter = "(objectClass=computer)"
Dim DirEntry As DirectoryEntry
Dim nom As String
Dim OsVersion As String
Dim Os As String
Dim ServicePack As String
Dim Ip As String
Dim largeInteger As Object
Dim lastLoggedOnDate As Date
Dim reboot As Date
Dim rebootTime As Object
SqlDataSourceControl2.ConnectionString="server='(local)'; trusted_connection=true; database='pspintranet'"
SqlDataSourceControl2.SelectCommand="Select * from Servers"
call SQLExecuteQuery("TRUNCATE TABLE Servers")
For Each result As SearchResult In searcher.FindAll
DirEntry = result.GetDirectoryEntry
'Response.Write("Nom : " + DirEntry.Properties("Name").value)
'Response.write("Os_version : " + DirEntry.Properties("operatingSystemVersion").value)
'Response.write(" Os : " + DirEntry.Properties("operatingSystem").value)
'Response.write("ServicePack :" + DirEntry.Properties("operatingSystemServicePack").value)
'Response.write("userPrincipalName :" + DirEntry.Properties("userPrincipalName").value)
nom = DirEntry.Properties("Name").value
'insertion des ip dans la DB.
Dim IPHost As IPHostEntry = Dns.Resolve(DirEntry.Properties("Name").value)
Dim addressList As IPAddress() = IPHost.AddressList
Dim b As IPAddress = addressList(0) ' récupère la première adresse
Ip = b.ToString()
OsVersion = DirEntry.Properties("operatingSystemVersion").value
Os = DirEntry.Properties("operatingSystem").value
ServicePack = DirEntry.Properties("operatingSystemServicePack").value
'reboot = restart(rebootTime)
'call restart()
'lastLoggedOnDate = ConvertLargeIntToDate(largeInteger)
'largeInteger = DirEntry.Properties("lastLogOn").Value
'lastLoggedOnDate = ConvertLargeIntToDate(largeInteger)
'last_logon = lastLoggedOnDate
'lblError.Text += nom & " - " & OsVersion & " - " & Os & " - " & ServicePack & "<br>"
'Dim IPHost As IPHostEntry = Dns.Resolve(DirEntry.Properties("Name").value)
'Dim addressList As IPAddress() = IPHost.AddressList
'Dim a As IPAddress = addressList(0) ' récupère la première adresse
'lblError.Text += "INSERT INTO Servers (nom,Ip,ServicePack,OsVersion,OsName) VALUES('"& nom &"','" & Ip & "','" & ServicePack &"','" & OsVersion &"', '" & Os &"' )" & "<br>"
call SQLExecuteQuery("INSERT INTO Servers (nom,Ip,ServicePack,OsVersion,OsName) VALUES('"& nom &"','" & Ip & "','" & ServicePack &"','" & OsVersion &"', '" & Os &"' )")
Next
MxDataGrid1.DataBind()
End Sub
Function SQLExecuteQuery(ByVal sqlQuery As String) As String
Dim a As String
Dim objConnect As New SqlConnection("server='(local)'; trusted_connection=true; database='pspintranet'")
objConnect.Open()
Dim objCommand As New SqlCommand(sqlQuery, objConnect)
a = objCommand.ExecuteNonQuery()
Return a
End Function
Private Function ConvertLargeIntToDate(ByVal largeInteger As Object) As Date
Dim typ As Type = largeInteger.GetType()
Dim highPart As Integer = CInt(typ.InvokeMember("HighPart", Reflection.BindingFlags.GetProperty, Nothing, largeInteger, Nothing))
Dim lowPart As Integer = CInt(typ.InvokeMember("LowPart", Reflection.BindingFlags.GetProperty, Nothing, largeInteger, Nothing))
Dim fileTime As Int64 = Convert.ToInt64(highPart * (2 ^ 32))
Return (DateTime.FromFileTime(fileTime))
End Function
Sub Button1_Click(sender As Object, e As EventArgs)
'txtPing.Text = Nothing
'pingopts.Ttl = Convert.ToInt32(txtTTL.Text)
Dim ping As Ping = New Ping()
Dim pingreply As PingReply = ping.Send(TextBox1.Text)
response.write("Reply from : " & TextBox1.Text)
Response.Write("<br>")
Response.Write("<br>")
response.write("Time :" & pingreply.RoundtripTime)
Response.Write("<br>")
Response.Write("<br>")
'response.write("TTL :" & Pingreplay.Ttl.ToString())
'Response.Write("<br>")
'Response.Write("<br>")
response.write("Buffer Size :" & pingreply.Buffer.Length.ToString())
Response.Write("<br>")
Response.Write("<br>")
End Sub
</script>
<html>
<head>
</head>
<body>
<form runat="server">
<p>
<wmx:SqlDataSourceControl id="SqlDataSourceControl2" runat="server" UpdateCommand="" DeleteCommand=""></wmx:SqlDataSourceControl>
<wmx:MxDataGrid id="MxDataGrid1" runat="server" BorderStyle="None" BorderWidth="1px" BorderColor="#CCCCCC" BackColor="White" DataMember="Servers" DataSourceControlID="SqlDataSourceControl2" DataKeyField="nom_id" CellPadding="3" AllowSorting="True" AllowPaging="False">
<FooterStyle backcolor="White" forecolor="#000066"></FooterStyle>
<HeaderStyle backcolor="#006699" font-bold="True" forecolor="White"></HeaderStyle>
<ItemStyle forecolor="#000066"></ItemStyle>
<PagerStyle mode="NumericPages" horizontalalign="Center" backcolor="White" forecolor="#000066"></PagerStyle>
<SelectedItemStyle backcolor="#669999" font-bold="True" forecolor="White"></SelectedItemStyle>
</wmx:MxDataGrid>
<asp:Label id="lblError" runat="server"></asp:Label>
</p>
<p>
</p>
<p>
</p>
<p>
</p>
<p>
<asp:TextBox id="TextBox1" runat="server"></asp:TextBox>
</p>
<p>
<asp:Button id="Button1" onclick="Button1_Click" runat="server" Text="Ping"></asp:Button>
</p>
</form>
</body>
</html> |
Partager