CrowdStrikeCore table. Interim CMDB table

[hudatolah]

Code: Select all

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO
DROP TABLE [dbo].[CrowdStrikeCore]

CREATE TABLE [dbo].[CrowdStrikeCore](
	[hostname] [varchar](128) NOT NULL,
	[machine_domain] [varchar](128) NULL,
	[external_ip] [varchar](128) NULL,
	[hrb_status_active] [bit] NULL,
	[bios_manufacturer] [varchar](64) NULL,
	[bios_version] [varchar](64) NULL,
	[product_type_desc] [varchar](128) NULL,
	[serial_number] [varchar](64) NOT NULL,
	[system_manufacturer] [varchar](64) NULL,
	[system_product_name] [varchar](64) NULL,
	[modified_timestamp] [datetime] NULL,
	[first_seen_create_date] [datetime] NULL,
	[last_seen] [datetime] NULL,
	[agent_local_time] [datetime] NULL,
	[mac_address] [varchar](64) NULL,
	[local_ip] [varchar](64) NULL,
	[device_id] [varchar](64) NULL,
	[cid] [varchar](64) NULL,
	[agent_version] [varchar](64) NULL,
	[ou] [varchar](256) NULL,
	[os_version] [varchar](64) NULL,
	[os_build] [varchar](64) NULL,
	[platform_name] [varchar](64) NULL,
	[reduced_functionality_mode] [varchar](64) NULL,
	[device_policies] [varchar](256) NULL,
	[groups] [varchar](256) NULL,
	[site_name] [varchar](128) NULL,
	[classid] [varchar](64) NULL,
	[last_update] [datetime] NULL,
	[last_update_by] [varchar](64) NULL,
	[instanceid] [varchar](37) NULL

) ON [PRIMARY]
GO

[hudatolah]

Code: Select all

select * from dbo.CrowdStrikeCore

 insert into dbo.CrowdStrikeCore values 
 ('hostname','hrblock.com','255.255.255.255','1','Atari Inc.','2.0','Game Console','SN00000001','Atari','system_product_name',
getdate() ,getdate(),getdate() ,getdate() ,
 'mac_address','local_ip' ,'device_id','cid','agent_version','ou','os_version','os_build','platform_name','reduced_functionality_mode','device_policies','groups'
,'site_name','classid',getdate(),'last_update_by',newid()) 
 
SELECT TOP (1000) [hostname]
      ,[machine_domain]
      ,[external_ip]
      ,[hrb_status_active]
      ,[bios_manufacturer]
      ,[bios_version]
      ,[product_type_desc]
      ,[serial_number]
      ,[system_manufacturer]
      ,[system_product_name]
      ,[modified_timestamp]
      ,[first_seen_create_date]
      ,[last_seen]
      ,[agent_local_time]
      ,[mac_address]
      ,[local_ip]
      ,[device_id]
      ,[cid]
      ,[agent_version]
      ,[ou]
      ,[os_version]
      ,[os_build]
      ,[platform_name]
      ,[reduced_functionality_mode]
      ,[device_policies]
      ,[groups]
      ,[site_name]
      ,[classid]
      ,[last_update]
      ,[last_update_by]
  FROM [dbo].[CrowdStrikeCore]